Exceljet

Quick, clean, and to the point

Excel MEDIAN Function

Excel MEDIAN function
Summary 

The MEDIAN function returns the median (middle number) in a group of supplied numbers. For example, =MEDIAN(1,2,3,4,5) returns 3.

Purpose 
Get the median of a group of numbers
Return value 
A number representing the median.
Syntax 
=MEDIAN (number1, [number2], ...)
Arguments 
  • number1 - A number or cell reference that refers to numeric values.
  • number2 - [optional] A number or cell reference that refers to numeric values.
Version 
Usage notes 
  • When the total number of supplied numbers is odd, the median is calculated as the middle number in the group.
  • When the total number of supplied numbers is even, the median is calculated as the average of the two numbers in the middle.
  • Cells that contain text, logical values, or no value are ignored.
  • Numbers can be supplied as numbers, ranges, named ranges, or cell references that contain numeric values. Up to 255 numbers can be supplied.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas