AVG Function

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.
    • number2
    • ...
    —[optional]
    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 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