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