The Excel MEDIAN Function

Related Functions:
AVERAGE Function
MODE Function

Function Description

The Excel MEDIAN function returns the statistical median (the middle value) of a list of supplied numbers.

The syntax of the function is:

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

where the number arguments are a set of one or more numeric values (or arrays of numeric values), for which you want to calculate the median

Note that:



Excel Median Function Examples

The following spreadsheet shows three examples of the Median function:

 Formulas:
  A B
1 1 =MEDIAN( A1:A7 )
2 4.5 =MEDIAN( A1:A7, 12 )
3 7 =MEDIAN( A1:A8 )
4 8  
5 9  
6 13  
7 14  
8    
 Results:
  A B
1 1 8
2 4.5 8.5
3 7 8
4 8  
5 9  
6 13  
7 14  
8    

Note that, in the above examples:


For further details of the Excel Median function, see the Microsoft Office website.