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.
Returns a number. The middle value; even counts average the two central values. Text and blanks in ranges are ignored.
Position versus magnitude. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =MEDIAN(A2:A8) | 78 | Middle of the five scores |
| =MEDIAN(B2:B8) | 950 | Middle of the sales figures |
| =MEDIAN(1,2,3) | 2 | Odd count: the middle value |
| =MEDIAN(1,2,3,4) | 2.5 | Even count: mean of middle two |
| =AVERAGE(A2:A8) | 72 | Mean, for comparison |
| =MEDIAN(5,1,9,3,7) | 5 | Unsorted input is fine |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to compare MEDIAN with AVERAGE.
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.
MEDIAN is a core statistical function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
MEDIAN is one piece. The full course walks the toolkit end to end with live, measured examples.