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 |