The Excel MEDIAN 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:
 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:


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