Enter your data into a single row or column
Click an empty cell where you want the median result to appear
Type `=MEDIAN(range)`
Replace `range` with the cell range 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
Ignore text and logical values in cells within the range
Use `=MEDIANIF` only if using a custom formula or add-in, since Excel does not have a built-in `MEDIANIF` function