Average the cells that meet a single condition.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
AVERAGEIF(range, criteria, [average_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)Result: 1,408
Average of column C where region is East.
Yes — cells with no value aren't counted, but zeros are.