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

Still need help? 

Use the Smartsheet Formula Template to view examples and practice working with functions in real-time. 


Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community