Average
Calculates the arithmetic mean of the values in a list of values, range(s), or list(s).
Syntax
Average(param1, param2, ...)Moyenne(param1, param2, ...)
param1 = first parameter to average (value, range, or list)
param2 = second parameter to average (value, range, or list)
... nth parameter to average (value, range, or list)
Remarks
This function accepts an unlimited number of parameters.
Empty cells and values are not counted when determining the total number of elements in the calculation.
Examples
Average(1, 2) = 1.5Moyenne(A1:B3) = arithmetic mean of all of the numerical values in the range A1:B3