The AVERAGE function
Returns the mean: the sum of the numbers divided by how many there are. Blank cells and text are skipped.
Syntax
AVERAGE(number1, [number2], ...)- number1
- The first number, cell or range.
- number2 (optional)
- More numbers or ranges.
Examples
E1=AVERAGE(C2:C6)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Product | Sales | 330 | |
| 2 | North | Shoes | 500 | ||
| 3 | South | Shoes | 300 | ||
| 4 | North | Bags | 250 | ||
| 5 | North | Shoes | 420 | ||
| 6 | South | Bags | 180 |
B1=AVERAGE(2,4,9)
| A | B | |
|---|---|---|
| 1 | 5 |
Practice AVERAGE
Read the guide
Questions
Does AVERAGE count blank cells?
No. Blank cells and text are skipped, so they do not pull the average down. A cell that holds 0 does count.