The MEDIAN function returns the statistical median of the given numbers.

Syntax

=MEDIAN(num_1,[num_2], … )

Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.

  • If a supplied array contains text and logical values, these values are ignored when calculating the median
  • If there is an even number of values in the supplied data set, the average of the two middle values is returned

Arguments

Argument Description
num_1 The first number, cell reference, or range for which you want the median
[num_2], … Optional. Additional numbers, cell references or ranges for which you want the median, up to a maximum of 255

Examples

  A B C D
1 Data      
2 2      
3 3      
4 3      
5 5      
6 7      
7 10      
8        
9 Formula Result Notes
10 =MEDIAN(A2:A6) 3 Median of the 5 numbers in the range A2:A6. Because there are 5 values, the third is the median
10 =MEDIAN(A2:A7) 4 Median of the 6 numbers in the range A2:A7. Because there are six numbers, the median is the midway point between the third and fourth numbers
11 =MEDIAN(A2:A7,15,20) 6 Median of the 8 numbers in the range A2:A7, 15, and 20. Because there are eight numbers, the median is the midway point between the fourth and fifth numbers

The MEDIAN function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution. The three most common measures of central tendency are:

  • Average – the arithmetic mean, which is calculated by adding a group of numbers and then dividing by the count of those numbers.
  • Median – the middle number of a group of numbers; i.e. half the numbers have values that are greater than the median and half the numbers have values that are less than the median. For example, the median of 2, 3, 3, 5, 7, and 10 is 4.
  • Mode – the most frequently occurring number in a group of numbers. For example, the mode of 2, 3, 3, 5, 7, and 10 is 3.