For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Statistical Function

MEDIAN Function

Returns the median of the given numbers, which is the number in the middle of a set of numbers.


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Syntax

MEDIAN(number1,number2,...)

  • number1  Required. A number, range, or array for which you want the median number.
  • number2, ...  Optional. Subsequent numbers, ranges, or arrays for which you the median number.

Applies To

Excel 2003 and above

Remarks

MEDIAN ignores cells that contain text, logical values, or empty cells in an array or reference argument. But cells with the value of zero are included.

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

With an odd number of items, MEDIAN returns the number with half above and half below:

Example of Excel's MEDIAN function


With an even number of items, Excel returns the average of the numbers in the middle:

Example of Excel's MEDIAN function

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards