Skip to content
FormulaCraft

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

Runs server-side · free · no signup

How it works

  1. 1B2:B100 is the range of numbers.
  2. 2MEDIAN sorts them and returns the middle one.
  3. 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”

Related

SUMIFSUMIFSCOUNTIF

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

Last reviewed: