Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

MEDIAN

Returns the median value in a numeric dataset.

Sample Usage

MEDIAN(1,2,3,4,5)
MEDIAN(A1:A6)

Syntax

MEDIAN(value1, [value2, ...])

  • value1 - The first number or range to consider while calculating the median value.
  • value2, .. - [OPTIONAL] Additional numbers or ranges to consider.

Examples

MEDIAN(1,2,3,4,5) returns a value of 3.
MEDIAN(A1:A6) returns the median of the 6 numbers in the range A1 through A6.
 

Notes

  • Any text encountered in the value arguments will be ignored.
  • MEDIAN finds the center value of the dataset rather than the mean. To find the mean, use AVERAGE or AVERAGEA.