Returns the average of all cells that meet multiple criteria.
Sintassi
AVERAGEIFS(average_range, criteria_range1, criteria1, ...)Argomenti
average_rangeobbligatorio
The actual range of cells to average.
criteria_range1obbligatorio
The range of cells to evaluate against the first criteria.
criteria1obbligatorio
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.