Home/Formulas/Math/AVERAGE
Matheasy

AVERAGE()

Returns the numerical average value in a dataset, ignoring text.

Syntax
fx
=AVERAGE(value1, [value2, ...])
Try it
F2
→
24,937.5
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Empty cells are excluded from the average; cells containing 0 are NOT, and they pull the average down. Use AVERAGEIF(range, "<>0") to skip zeros.
  • Text cells are silently ignored. To average a column that mixes numbers and text-formatted numbers, coerce first.
  • Returns #DIV/0! if every cell in the range is empty or text. Wrap in IFERROR if the range may legitimately have no numbers.
Related formulas
MEDIAN()
Returns the median (middle value) of a dataset. Half the values are below, half above.
Used by
MEDIAN()
Returns the median (middle value) of a dataset. Half the values are below, half above.
More Math formulas →Keyboard shortcuts for Sheets →