Calculates the middle value of a set of numbers

`MEDIAN(number1, [number2], ...)`

- number1 - required, a number or cell reference
- [number2], ... - [OPTIONAL] numbers or cell references, up to a total of 255 arguments

`=MEDIAN(A2:A6)`

The MEDIAN function returns the median of any given range of numbers. For example, this returns the median of the five numbers in the range A2:A6. The median number is the one in the very middle of the range.

`=MEDIAN(A2:A7)`

If the range contains an even number of elements, the MEDIAN function will return the number halfway between the two middle elements. For example, this returns the median of the six numbers in the range A2:A7, which is the midway point between the third and fourth numbers.

The MEDIAN function is used to calculate the median value of a given set of numbers. The median is the middle number in a group of numbers.

- The MEDIAN function gets the middle number in a group of numbers, picking the middle number in a set of odd numbers and the average of the middle two numbers in a set of even numbers.
- MEDIAN accepts references to cells, ranges, or constants as arguments and accepts any arguments in any combination.
- MEDIAN ignores empty cells, text values, and logical values (TRUE and FALSE).
- If there are no numbers, MEDIAN throws a #NUM! error.

The MEDIAN function calculates the median of a set of numbers. The numbers are provided as arguments.

The MEDIAN function accepts many types of arguments. The full list of argument types that the MEDIAN function accepts is numbers, names, arrays, and references.

The MEDIAN function averages the two middle numbers in the set if the set contains an even number of values.

MEDIAN accepts numbers that appear as logical values or text representations in its arguments. It ignores logical values, text, and empty cells that appear in references in its arguments, however.

Yes, MEDIAN includes zero cells in its calculation.

The MEDIAN function is for measuring central tendency, which is the center of a statistical distribution of a set of numbers.

Drop CSV