MEDIAN

Name

MEDIAN —
MEDIAN(n1, n2, ...)

Description

MEDIAN returns the median of the given data set.

Strings and empty cells are simply ignored. If even numbers are given MEDIAN returns the average of the two numbers in the middle.

See also

AVERAGE , COUNT , COUNTA , DAVERAGE , MODE , SUM