Table of Contents

## Summary

The Excel MEDIAN function calculates the median value from a set of user provided values, cells, and/or ranges. The MEDIAN function is a popular statistical Excel function. The cells and ranges do not have to be contiguous.

## Formula

=MEDIAN(number1, [number2], …)

## Arguments (inputs)

number1 = the first number to be included in the median calculation, can be either a number, cell reference, or range reference

number2 = [optional] all additional numbers to be included in the median calculation are optional

## Return value

The MEDIAN formula returns the mathematical median of all of the numbers, cells, and/or ranges in the form of a single number.

## Example

In the example above the MEDIAN formula in cell N6 calculates median of the range of cells between I6:I35, which is the median age of college applicants of the example dataset.

=MEDIAN(I6:I35)

The resulting median of the range is returned in cell N6: 23 years old.