Averaging by Criteria With AVERAGEIF
Average only the values that meet a given test.
Averaging Only What Matches
You have totaled with SUMIF and counted with COUNTIF. The third member of the family is AVERAGEIF, which finds the average of only the values that meet a condition.
Instead of averaging every sale, you can average just the East region sales, or just the scores above 50. It mixes a filter and a mean into one clean step.
The AVERAGEIF Pattern
AVERAGEIF uses the same three-part shape as SUMIF:
- range the cells to test
- criteria the condition
- average_range the cells to average
It looks through range, finds matches, then averages the corresponding cells in average_range.
=AVERAGEIF(range, criteria, average_range)All lessons in this course
- Summing by Criteria With SUMIF
- Counting by Criteria With COUNTIF
- Averaging by Criteria With AVERAGEIF
- Using Wildcards in Criteria