Returns the average of all cells that meet multiple criteria.
Syntaxis
AVERAGEIFS(average_range, criteria_range1, criteria1, ...)Argumenten
average_rangevereist
The actual range of cells to average.
criteria_range1vereist
The range of cells to evaluate against the first criteria.
criteria1vereist
The condition that defines which cells in criteria_range1 are averaged.
The AVERAGEIFS function calculates the arithmetic mean of cells that satisfy a set of given conditions. You can specify multiple ranges and corresponding criteria to filter the data before calculating the average.
=AVERAGEIFS(B2:B5, A2:A5, "Sales", C2:C5, ">100")→150Calculates the average of values in B2:B5 where column A is 'Sales' and column C is greater than 100.
Select the target cell
Click on the cell where you want the result to appear.
Enter the formula
Type =AVERAGEIFS( and select the range to average, followed by your criteria ranges and conditions.
Close and execute
Close the parenthesis and press Enter to see the calculated average.
Yes, you can use the asterisk (*) and question mark (?) as wildcards in text-based criteria.