ReferenceFunctionsStatistics Functions
MEDIAN
MEDIAN: Returns the middle value of a numeric data set.
Summary
For an even number of values, MEDIAN returns the average of the two center values.
Remarks
- Ignores non-numeric values in referenced ranges.
- Returns
#NUM!when no numeric values are available. - Supports both scalar arguments and range inputs.
Examples
Median of an odd-sized set
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
3
Median of an even-sized range
Grid
| Cell | Value | |
|---|---|---|
Formula
=
Result
Not evaluated yet.
Expected
6
Related functions
FAQ
When does MEDIAN return #NUM!?
MEDIAN returns #NUM! when no numeric values are available after filtering/coercion.
Runtime metadata
Category
Statistics
Signature
MEDIAN(arg1…: Number (Range))This function accepts a repeating argument pattern (min args: 1).
Arity
min 1, max variadic
Arguments
arg1Number · Range · coercion NumberLenientText
Caps
PUREREDUCTIONNUMERIC_ONLY
Source