MEDIAN function


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

Percentile function

List of Statistical spreadsheet functions

This site uses cookies to store information on your computer. More info...