Averaging Across Conditions With AVERAGEIFS
Average values filtered by more than one test.
Averaging Only What Matters
AVERAGEIFS calculates the mean of values that meet several conditions at once. Instead of averaging every sale, you can ask What was the average East region sale in January?
It completes the trio: SUMIFS totals, COUNTIFS counts, and AVERAGEIFS finds the middle value — all using the same multi-criteria style. If you know one, you almost know all three.
The AVERAGEIFS Structure
AVERAGEIFS mirrors SUMIFS exactly. The values to average come first, then the condition pairs.
average_range— the numbers to averagecriteria_range1,criteria1criteria_range2,criteria2
Behind the scenes it sums the matching values and divides by how many matched — essentially SUMIFS divided by COUNTIFS, in one clean function.
=AVERAGEIFS(average_range, criteria_range1, criteria1, criteria_range2, criteria2)All lessons in this course
- Summing Across Conditions With SUMIFS
- Counting Across Conditions With COUNTIFS
- Averaging Across Conditions With AVERAGEIFS
- Date Ranges in Criteria Functions