Average & AverageRange
The Average and AverageRange formulas allow you to calculate the average of a number of values.
Syntax
Average
(Parameter0 + Parameter1 + Parameter2 + etc.)
The parameters are references to list items.
AverageRange
(Parameter0:Parameter1) / # Parameters. This will calculate the average value of a range of items.