MEDIAN

MEDIAN returns the middle number when values are sorted. It resists skew from a few very large or small values, so it often describes "typical" better than AVERAGE.

Excel

=MEDIAN(B2:B100)

Google Sheets

=MEDIAN(B2:B100)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1B2:B100 is the range of numbers.
2MEDIAN sorts them and returns the middle one.
3With an even count, it averages the two middle values.

Need a version for your data?

Try: “Find the median value of the numbers in column B”

SUMIF SUMIFS COUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

MEDIAN

Try it with your data

How it works

Related