MEDIAN Function

Returns the value of the midpoint of the range of numbers.
Sample Usage
MEDIAN(Cost1:Cost5)
Syntax
MEDIAN(
  • number1
  • [
    • number2
    • ...
    ]
)
  • number1
    The numbers, cell reference, or range for which you want the median.
    • number2
    • ...
    —[optional]
    Additional numbers, cell references, or ranges for which you want the median.
Examples

This example references the following sheet information:

  Item Number Transaction Total Units Sold Price Per Unit
1 C001 1,170.00 78 15.00
2 C002 1,491.00 42 35.50
3 C003 812.00 217 200.00

Given the table above, here are some examples of using MEDIAN in a sheet:

Formula Description Result
=MEDIAN([Transaction Total]:[Transaction Total]) Gives the median of the Transaction Total column. 1,170.00
=IF([Price Per Unit]@row > 14, MEDIAN([Units Sold]:[Units Sold], " ")) If the Price Per Unit on each row is greater than 14, give the median of the Units Sold column, otherwise, do nothing. 78