Formulas > =MEDIAN()
How To Use MEDIAN() Function in Google Sheets
Description
How To Actually Use MEDIAN() in Sheets
MEDIAN(value1, [value2, ...])
Try MEDIAN yourself
Use the MEDIAN formula to calculate the median of the values in the range A1:A10. The correct answer should return the median value from this dataset.
Hints (2)
-
Remember that the MEDIAN function requires a range of numbers.
-
Make sure to include all the cells from A1 to A10 in your formula.
1 Better Sheets Tutorial
Use Min and Max for More Average Averages
What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.
AVERAGE()
MAX()
MEDIAN()
MIN()
Learn more about the MEDIAN() formula:
Generate a MEDIAN() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses MEDIAN(). 2 free AI generations, no signup. Members get unlimited use.
Generate a MEDIAN() formula