These docs are for v1.0. Click to read the latest docs for v1.2.

MEDIAN

Calculates the median of a list of numbers or lists of numbers.

Syntax

=MEDIAN(number1, number2, ..., numberN)

=MEDIAN(numberArray)

Arguments

ArgumentTypeDescription
numberNumber or ArrayA number or array of numbers to find the median of

📘

If an array of values is supplied, the array will be flattened when averaging. For example, =MEDIAN(ARRAY(1,ARRAY(2,3)),ARRAY(4),5) returns 3, the median of (1, 2, 3, 4, 5).

Examples

=MEDIAN(1, 2, 2, 3)2
Calculates the median of 1, 2, 2 and 3.

=MEDIAN([1, 2, 2, 3, 4], [5, 5, 3], 4)3
Calculates the median of an array containing the numbers 1, 2, 2, 3 and 4, and another array containing 5, 5, and the number 3, along with the number 4. Because the MEDIAN function flattens arrays, this is the same as the median of 1, 2, 2, 3, 4, 5, 5, 3 and 4.