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
-
—[optional]
- number2
- ...
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 theTransaction Total列。 | 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 theUnits Sold列。Otherwise, do nothing. | 78 |
Still need help?
Use theFormula Handbook templateto find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.