MEDIAN

Returns the median value in a numerical data set.

Sample usage

MEDIAN(A2:A100,B2:B100,4,26)

MEDIAN(1,2,3,4,5,C6:C20)

Syntax

MEDIAN(value1, [value2, …])

• value1 – The first value or range to consider when calculating the median value.

• value2, … – [ OPTIONAL ] – Additional values or ranges to consider when calculating the median value.

Notes

• Although MEDIAN is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.

• Any text encountered in the value arguments will be ignored.

• MEDIAN returns the centre value if the data set contains an odd number of values. If the combined value arguments contain an even number of values, MEDIAN will interpolate between the two centre values.

• MEDIAN finds the centre value of the data set rather than the mean. To find the mean, use AVERAGE or AVERAGEA.

See also

SMALL: Returns the nth smallest element from a data set, where n is user-defined.

RANK: Returns the rank of a specified value in a data set.

QUARTILE: Returns a value nearest to a specified quartile of a data set.

PERCENTRANK: Returns the percentage rank (percentile) of a specified value in a data set.

PERCENTILE: Returns the value at a given percentile of a data set.

MINA: Returns the minimum numerical value in a data set.

MIN: Returns the minimum value in a numerical data set.

MAXA: Returns the maximum numerical value in a data set.

MAX: Returns the maximum value in a numerical data set.

LARGE: Returns the nth largest element from a data set, where n is user-defined.

AVERAGEA: Returns the numerical average value in a data set.

AVERAGE: The AVERAGE function returns the numerical average value in a dataset, ignoring text.

Examples