MEDIAN
Finds the middle value of a list.
How it’s written
MEDIAN(range)Example
| A | B | |
|---|---|---|
| 1 | Name | Score |
| 2 | Amara | 72 |
| 3 | Ben | 90 |
| 4 | Chloe | 65 |
| 5 | Dev | 90 |
| 6 | Elena | 83 |
=MEDIAN(B2:B6)Result: 83
Sorted, the scores are 65, 72, 83, 90, 90, so 83 is the middle.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Use it instead of AVERAGE when a few extreme values would distort the picture.
Practice it properly
When the average misleads gives you real tasks, with your formulas tested on data you haven’t seen.