MEDIAN Formula Generator
Find the middle value of a range, the point half your numbers sit above and half below.
MEDIAN
Find the middle value of a range, the point half your numbers sit above and half below.
The cells to find the middle value of. Text, logical values, and empty cells are ignored; zeros are counted.
=MEDIAN(A2:A100)Worked Example
Four support response times in A2:A5: 12, 15, 18, and 22 minutes.
=MEDIAN(A2:A5)Returns: Returns 16.5. With an even count there is no single middle value, so MEDIAN averages the two middle numbers, 15 and 18.
Checks Before You Paste
- •With an even count of numbers, MEDIAN averages the two middle values, so the answer can be a number that appears nowhere in your data: 12 and 18 in the middle produce 15.
- •MEDIAN ignores text, TRUE/FALSE, and truly empty cells inside a range, but a cell holding 0 is a real number and counts. That blank-versus-zero distinction is the usual reason a median shifts after someone fills in the gaps.
- •MEDIAN is the 50% point of the data, so QUARTILE.INC(range, 2) returns exactly the same number while quart 1 and 3 give the quarter points. For the most common value use MODE.SNGL, which returns #N/A when nothing repeats, or MODE.MULT to list every tied winner - it spills down several cells in Microsoft 365 and needs Ctrl+Shift+Enter over a selected range in older Excel versions.