Quick Answer & Formula
Excel
Sheets
Beginner
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...]) AVERAGEIFS calculates the arithmetic mean of all numbers in average_range that satisfy all criteria rules. Place average_range as the first argument.
AVERAGEIFS Function in Excel & Google Sheets
The AVERAGEIFS function calculates the conditional mean of values meeting multiple filter rules.
1. Calculating Average Salary by Department
To find the average salary (E2:E100) for Senior level (C2:C100) employees in Finance (D2:D100):
=AVERAGEIFS(E2:E100, C2:C100, "Senior", D2:D100, "Finance")2. Safe Zero Handling with IFERROR
=IFERROR(AVERAGEIFS(E2:E100, D2:D100, "Marketing"), 0)
?
Frequently Asked Questions
Why does AVERAGEIFS return #DIV/0!?
AVERAGEIFS returns #DIV/0! if zero rows meet all specified criteria. Wrap the formula in IFERROR to return 0 or "N/A".