MEDIAN

Returns the median (middle value) of the specified arguments.

Syntax

MEDIAN( Number n1, [Number n2], ... ) → Number

Parameters

n1
n2
…

One or more numbers for which to find the median value.

Remarks

The arguments can be either numbers or logical values, or cells or arrays that contain numbers or logical values. Text and empty cells are ignored.

MEDIAN sorts the numbers smallest to largest. If given an odd number of values, MEDIAN returns the middle value. If given an even number of values, MEDIAN returns the arithmetic average of the two middle values.

Example

Formula

=MEDIAN(A1:A6)
=MEDIAN({1;3;4;11})

See Also

Function Reference
COUNT Function
COUNTA Function
SUM Function