Returns the average (mean) of the provided numbers.
Sample Usage
AVG(Cost1:Cost5)
Syntax
AVG(
- number1
- []
- number2
- ...
- number1—The number, cell reference, or range for which you want the average.
- —[optional]
- number2
- ...
Additional numbers, cell references, or ranges for which you want the average.
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 AVG in a sheet:
| Formula | Description | Result |
|---|---|---|
| =AVG([Transaction Total]:[Transaction Total]) | Averages the “Transaction Total” column. | 1,157.67 |
| =ROUND(AVG([Units Sold]:[Units Sold])) | Rounds the average of the “Units Sold” column. | 112 |
| =AVG(COLLECT([Units Sold]:[Units Sold], [Price Per Unit]:[Price Per Unit], <100)) | Averages values in the “Units Sold” column when their corresponding value in the "Price Per Unit" column is less than 100. | 60 |
Still need help?
Use the Formula Handbook template to 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.