The Excel MEDIAN Function

Basic 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:

Also note that in current versions of Excel (Excel 2007 & later), you can provide up to 255 number arguments to the Median function, but in Excel 2003, the function can only accept up to 30 number arguments.


Excel Median Function Examples

The following spreadsheet shows three examples of the Median function:

 Formulas:
 AB
11=MEDIAN( A1:A7 )
24.5=MEDIAN( A1:A7, 12 )
37=MEDIAN( A1:A8 )
48 
59 
613 
714 
8  
 Results:
 AB
118
24.58.5
378
48 
59 
613 
714 
8  

Note that, in the above examples:


Further details of the Excel Median function are provided on the Microsoft Office website.