Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu

MEDIAN function


MEDIAN(range) computes the median of the contents of the cells in the specified range. If one of the cells in range does not have a numeric value, but is empty or has a string value, then this cell will not be taken into account for calculating the median, or any of the other statistical functions.


MEDIAN(A1:A100) returns the median of the contents of cells A1 to A100.

Related functions