MEDIAN Function
Returns the middle number of a set.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Overview
MEDIAN sorts the numbers and returns the one in the middle. With an even count, it averages the two middle numbers.
Unlike AVERAGE, one very large or very small value barely moves it — which is why salaries and house prices are usually reported as medians.
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 — Middle sales result
Sorted, the sales are 39,800 · 48,500 · 48,500 · 50,000 · 55,400 · 62,000 · 71,250. The 4th of 7 is the middle.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Measure | Result |
| 2 | Ana | North | 62000 | Median | 50000 |
| 3 | Ben | South | 48500 | Average | 53635.71 |
| 4 | Cy | North | 50000 | ||
| 5 | Di | East | 71250 | ||
| 6 | Ed | South | 39800 | ||
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
Example 2 — Even number of values
The two middle values (2 and 3) are averaged.
Returns 2.5.
Example 3 — Resistant to outliers
One huge order changes the average a lot, the median hardly at all.
Returns 52,700 — while the average jumps to about 171,931.
Common mistakes
- Text and blanks are skipped, zeros aren't. A 0 standing in for missing data shifts the median down.
Notes
- Related functions: AVERAGE, MODE.SNGL, QUARTILE.INC, PERCENTILE.INC, 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.