fx =MEDIAN(A1:A100)ABCJan Score8782.3Feb Score92Mar Score78
📈 Statistical

MEDIAN Formula for Statistical

Find the middle value of a dataset. Copy-paste ready for Excel, Google Sheets, and Airtable.

=MEDIAN(A1:A100)
When you need this: When you analyze salaries (A1:A100) and want the middle value (not the average) to identify the "typical" salary.

How it works

  1. 1Sort values from lowest to highest (internally).
  2. 2Find the middle value (50th percentile).
  3. 3If even count, return average of two middle values.

Variations

MEDIAN excluding outliers
=MEDIAN(IF(A1:A100<100000,A1:A100))
Find quartiles (25th percentile)
=QUARTILE(A1:A100,1)

Related Formulas

AVERAGE — Calculate the average of a rangeStatisticalCOUNTIF — Count cells that meet a conditionStatisticalCOUNTIFS — Count cells meeting multiple conditionsStatisticalMAX / MIN — Find the largest or smallest value in a rangeStatistical

Need a formula that's not here?

Generate custom formula →