Stat · Nov 16, 2026

The MEDIAN function,
measured & explained.

MEDIAN finds the middle of a sorted set: half the values lie below it, half above. For an odd count it is the central value; for an even count it is the mean of the two central values. Because it depends only on position, not magnitude, it is robust to outliers — the reason median income or median house price is reported instead of the mean.

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

How MEDIAN works

Returns a number. The middle value; even counts average the two central values. Text and blanks in ranges are ignored.

=MEDIAN(number1, number2, ...)
number1The first number, reference or range.
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 — Middle vs mean

MEDIAN vs AVERAGE

Position versus magnitude. Click any row to load it.

Finding the middle

ExpressionResultWhy
=MEDIAN(A2:A8)78Middle of the five scores
=MEDIAN(B2:B8)950Middle of the sales figures
=MEDIAN(1,2,3)2Odd count: the middle value
=MEDIAN(1,2,3,4)2.5Even count: mean of middle two
=AVERAGE(A2:A8)72Mean, for comparison
=MEDIAN(5,1,9,3,7)5Unsorted input is fine
⚠ MEDIAN ignores text and blanks in a range, so MEDIAN(A2:A8)=78 uses only the five numbers. It does not sort your data in place; it only reads it.
Odd count → the middle value. Even count → the mean of the two middle values. MEDIAN is resistant to outliers; AVERAGE is not.
// 03 — Try it live

Interactive MEDIAN playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to compare MEDIAN with AVERAGE.

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 MEDIAN works

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

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

Master stat

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

  • Odd → middle, even → mean of middle two
  • Robust to outliers vs AVERAGE
  • Ignores text and blanks
  • No pre-sorting required
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked