What AVERAGEIFS does
AVERAGEIFS calculates an average only for records that satisfy several conditions at once. Use it when one filter is not enough, such as region plus month or category plus minimum score.
Practical examples
Average sales for one region in one month
=AVERAGEIFS(D2:D50,B2:B50,"West",C2:C50,"Jan")
This averages values in column D only when the row matches both criteria.
Average high-value orders for one rep
=AVERAGEIFS(E2:E50,B2:B50,"Morgan",E2:E50,">=1000")
This returns the average order value for Morgan's rows that are at least 1000.
Common mistakes and notes
All criteria ranges must be the same shape
AVERAGEIFS expects the criteria ranges to align with the average range row by row. Mismatched ranges are a common source of bad results.
AVERAGEIFS uses AND logic
Every condition has to be true for a row to be included. If you need OR logic, you usually combine multiple formulas.
No matching rows returns an error
If no records satisfy the criteria, AVERAGEIFS returns #DIV/0!. Wrap it with IFERROR when the report should show a friendlier fallback.