AVERAGE
StatisticalExcel 2007The arithmetic mean of numbers (blanks and text ignored).
Syntax
AVERAGE(number1, [number2], …)
Examples
=AVERAGE(B2:B30)
→
Good to know
- A blank cell is skipped; a cell holding 0 is included. AVERAGEA counts text as 0.
Related functions
More Statistical functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.