Stat · Nov 16, 2026

The AVERAGE function,
measured & explained.

AVERAGE adds the numeric values in its arguments and divides by how many numbers there were. Blank cells and text are skipped entirely while zeros are counted — a missing score should not drag the mean down, but a recorded zero should. With no numbers left it returns #DIV/0!.

D1
fx
=AVERAGE(…)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How AVERAGE works

Returns a number. Blanks and text in ranges are ignored; zeros are counted. No numbers gives #DIV/0!.

=AVERAGE(number1, number2, ...)
number1The first number, reference or range to average.
number2, ...Optional additional numbers or ranges (up to 255).
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — What gets counted

AVERAGE inclusion rules

A range with a blank and a text cell, measured live. Click any row to load it.

Inclusion, measured

ExpressionResultWhy
=AVERAGE(A2:A6)72Mean of five scores
=AVERAGE(B2:B6)1110Mean of five sales
=AVERAGE(A2:A8)72Blank and text ignored
=AVERAGE(85,92,78)85Direct numbers
=AVERAGE(A2:A4)85First three scores
=ROUND(AVERAGE(B2:B8),2)978.57All sales to 2 dp
=ROUND(AVERAGE(A2,A4,A6),2)69.33Selected cells
=AVERAGEIF(C2:C8,"West",A2:A8)76Conditional mean (West)
⚠ An empty or all-text range returns #DIV/0!, not 0. Guard with IFERROR(AVERAGE(range),0) when a zero default is acceptable.
AVERAGE ignores blanks and text but counts zeros; AVERAGEA instead counts text as 0, so the two differ on messy ranges.
// 03 — Try it live

Interactive AVERAGE playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to see how blanks, text and zeros change the mean.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where AVERAGE works

AVERAGE is a core statistical function present in every Excel version and platform.

PlatformSupportNotesGotcha
✓ Supported full AVERAGE◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master stat

AVERAGE is one piece. The full course walks the toolkit end to end with live, measured examples.

  • Blanks and text skipped, zeros counted
  • AVERAGEA counts text as 0
  • Guard empty ranges with IFERROR
  • Wrap ROUND for tidy decimals
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked