How to Work Out the Median in Excel?

Select an empty cell

Type `=MEDIAN(range)`

Replace `range` with the cells you want to analyze, such as `A1:A10`

Press Enter

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

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

Ignore blank cells and text values in the selected range

Use the result shown in the cell as the median

Suggested for You

Trending Today