AVERAGE Function

Returns the average (arithmetic mean) of numbers.

Category

Statistical

Available in

All versions, Microsoft 365

Returns

A number

Taught hands-on in Level 2: Essential Formulas & Everyday Logic · Frequently Used Functions module

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

=AVERAGE(number1, [number2], …)

Arguments

ArgumentRequired?What it does
number1YesA number, cell or range.
number2, …NoUp to 255 more numbers, cells or ranges.

Examples

Example 1 — Average sales per rep

One range covers the whole column of sales.

E2fx=AVERAGE(C2:C8)
ABCDE
1RepRegionSalesMeasureResult
2AnaNorth62000Average53635.71
3BenSouth48500
4CyNorth50000
5DiEast71250
6EdSouth39800
7FayNorth55400
8GusEast48500
=AVERAGE(C2:C8) Explain

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.

D2fx=AVERAGE(B2:B8)
ABCD
1NameScoreAverage
2Ana8262.5
3Benabsent
4Cy91
5Di
6Ed77
7Fay0
8Guspending
=AVERAGE(B2:B8) Explain

(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

Kyle Stott

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.