AVERAGEIF()
Averages the cells in a range that meet a single condition.
AVERAGEIF(range, criteria, [average_range])AVERAGEIF works like SUMIF, but divides by the count of matches instead of returning the total. It ignores non-matching cells entirely — they don't count toward the average or its denominator.
If no cells match criteria, AVERAGEIF returns #DIV/0!.
Arguments
- range
- The range to test against criteria.
- criteria
- The condition that decides which cells to include.
- average_rangeoptional
- The range to average when criteria matches. Defaults to range if omitted.
Examples
=AVERAGEIF(A2:A20, "North", C2:C20)→3,067
Averages column C only where column A says North.