AVERAGE Function
Returns the average (arithmetic mean) of numbers.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Overview
AVERAGE adds up the numbers you give it and divides by how many there are.
In a range, text, TRUE/FALSE and empty cells are skipped — but zeros count. To include text and logical values, use AVERAGEA; to average only rows that meet a condition, use AVERAGEIF or AVERAGEIFS.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number1 | Yes | A number, cell or range. |
| number2, … | No | Up to 255 more numbers, cells or ranges. |
Examples
Example 1 — Average sales per rep
One range covers the whole column of sales.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Measure | Result |
| 2 | Ana | North | 62000 | Average | 53635.71 |
| 3 | Ben | South | 48500 | ||
| 4 | Cy | North | 50000 | ||
| 5 | Di | East | 71250 | ||
| 6 | Ed | South | 39800 | ||
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
Wrap it in ROUND(…,0) to show 53,636.
Example 2 — Blanks and text are skipped, zeros aren't
Ben and Gus have text, Di is blank, and Fay scored 0.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Score | Average | |
| 2 | Ana | 82 | 62.5 | |
| 3 | Ben | absent | ||
| 4 | Cy | 91 | ||
| 5 | Di | |||
| 6 | Ed | 77 | ||
| 7 | Fay | 0 | ||
| 8 | Gus | pending |
(82 + 91 + 77 + 0) ÷ 4 = 62.5. Fay's 0 pulls the average down; Ben, Di and Gus are ignored.
Common mistakes
- #DIV/0! There are no numbers to average — the range is empty or holds only text. Wrap it in IFERROR to show something friendlier.
- Numbers stored as text. Values imported as text (often left-aligned with a green triangle) are skipped. Convert them with VALUE or Data › Text to Columns.
Notes
- To ignore zeros, use =AVERAGEIF(B2:B8,"<>0").
- Related functions: AVERAGEA, AVERAGEIF, AVERAGEIFS, MEDIAN, TRIMMEAN.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.