How to Use Excel to Calculate Median?

Select an empty cell where you want the median to appear

Type `=MEDIAN(range)`

Replace `range` with the cells containing your numbers, such as `=MEDIAN(A1:A10)`

Press Enter

Use multiple ranges if needed, such as `=MEDIAN(A1:A10,C1:C10)`

Include individual numbers if needed, such as `=MEDIAN(5,10,15)`

Ignore blank cells automatically

Use the formula on filtered or visible data as needed

Copy the formula to other cells if you need medians for different data sets

Suggested for You

Trending Today