MEDIAN

Formulas / MEDIAN
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

Examples

  • =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.


Summary

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.

Frequently Asked Questions

What is MEDIAN Function?
The MEDIAN function calculates the median of a set of numbers. The numbers are provided as arguments.
Which arguments are accepted by the MEDIAN Function?
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.
How does MEDIAN Function handle even numbers of values?
The MEDIAN function averages the two middle numbers in the set if the set contains an even number of values.
What about logical values and text representations in the arguments?
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.
Does MEDIAN Function include zero cells?
Yes, MEDIAN includes zero cells in its calculation.
What is the purpose of the MEDIAN Function?
The MEDIAN function is for measuring central tendency, which is the center of a statistical distribution of a set of numbers.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV