Average the cells that meet a single condition.
Syntax
AVERAGEIF(range, criteria, [average_range])Arguments
rangerequired
The cells to test.
criteriarequired
The condition, e.g. "East" or ">100".
average_rangeoptional
The cells to average; defaults to range.
AVERAGEIF returns the mean of values matching one criterion — for example, average sales for a single region. For multiple conditions, use AVERAGEIFS.
=AVERAGEIF(B2:B100, "East", C2:C100)→1,408Average of column C where region is East.
Set the test range
Point at the column holding the condition.
Give the average range
Add it when the values to average differ from the test column.
Yes — cells with no value aren't counted, but zeros are.