AVERAGEIFS function
Excel » Functions » Statistical » AVERAGEIFS function »
How to use the AVERAGEIFS function
The AVERAGEIFS function returns the average of cell values that evaluates to TRUE for multiple criteria. Formula in cell F6: =AVERAGEIFS(D3:D8,B3:B8,F3,C3:C8,G3) […]