The AVERAGE function
The average of the numbers in a range. It all depends on what it counts: zeros, yes; empty cells and text, no.
Syntax
=AVERAGE(number1, [number2], …)
In a French Excel: =MOYENNE(nombre1; [nombre2]; …).
Arguments
- number1, number2…: numbers, cells or ranges.
An example
=AVERAGE(C2:C50)
The average of column C; an empty cell does not count, a 0 does.
Pitfalls
- A replacement zero (put there by IFERROR) lowers the average; prefer an empty cell.
- No number at all: #DIV/0!.
Going further
- AVERAGEIF and AVERAGEIFS.
- Column profile: average, median and outliers of every column.
Frequently asked questions
- How do I average without the zeros?
=AVERAGEIF(C2:C50,"<>0").