Statistical
Modern
AVERAGE
Returns the arithmetic mean of the numbers in a range.
Available in All versions
Syntax
AVERAGE(number1, [number2])What it returns
The average of the supplied numbers.
Arguments
| Argument | Required | Description |
|---|---|---|
number1 |
Yes | The first number or range. |
number2 |
No | Additional numbers or ranges (up to 255). |
Example
| A | |
|---|---|
| 1 | Amount |
| 2 | 10 |
| 3 | 20 |
| 4 | 30 |
| 5 | 40 |
Result
25
AVERAGE is the sum divided by how many numbers there are (100 / 4 = 25).
=AVERAGE(B2:B100)Important to know
Ignores text and empty cells, but counts zeros.
Empty cells are skipped, not treated as 0.