The Avg function calculates the average value of a column of numbers.Β The average value of a column is equal to the sum of the values divided by the number of values.
Syntax
Avg(\[column\])
- column (required) - the column of numbers that is evaluated for the average.
Example
Avg(\[Profit\])
- Calculate the average profit in a group.
Avg(\[Population 2010\] - \[Population 2000\])
- Calculate the average change in population in a group.
Updated 3 months ago
Related resources