MEDIAN

Get the median (middle value) of a set of numbers.

Syntax

MEDIAN(value1,

[value2]

)

value1

A number, cell, range, or JSON array to include in the median. For example: 20, A3, or A1:A20.

[optional] value2

Additional numbers, cells, ranges, or JSON array to include in the mode. For example: 6, A4, or B1:B20.

MEDIAN(A1:A5) returns 2