Article updated on April 19, 2018

The MEDIAN function calculates the median based on a group of numbers. The median is the middle number of a group of numbers.

The picture above demonstrates the MEDIAN function in cell D3. The middle number of 1, 1, 2, 2, 2, 6 is 2.

If the group contains an even number of numbers the MEDIAN function calculates the average of the two numbers in the middle.

Another example, the middle number of 1, 1, 2, 3, 4, 6 is 2.5.

Excel Function Syntax

MEDIAN(number1, [number2], ...)


number1 Required. A constant or a reference to a cell or cell range which contains numbers.
[number2] Optional. Up to 254 additional arguments.

Recommended article

How to use the AVERAGE function

Calculates the average of numbers in a cell range. In other words, the sum of a group of numbers and […]