# MEDIAN function

Returns the median of the given numbers. The median is the number in the middle of a set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less.

## Syntax

MEDIAN(number1,number2,...)

Number1, number2, ...     are 1 to 30 numbers for which you want the median.

## Remarks

• The arguments should be either numbers or column references that contain numbers.

• If a column reference argument contains text, logical values, or is empty, those values are ignored; however, arguments with the value zero are included.

• If there is an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle. See the second formula following.

## Examples

Col1

Col2

Col3

Col4

Col5

Col6

Formula

Description (Result)

1

2

3

4

5

6

=MEDIAN([Col1],[Col2],[Col3],[Col4],[Col5])

Median of the first 5 numbers in the list (3)

1

2

3

4

5

6

=MEDIAN([Col1],[Col2],[Col3],[Col4],[Col5],[Col6])

Median of all the numbers, or the average of 3 and 4 (3.5)