AVERAGE() returns the average value for a set of specified numbers.
Use of variable arrays as a parameter is supported for this function. This means that a list of values can be provided using a single variable array. For more information see Variable Arrays.
AVERAGE(N1, N2 <,N3 ...>)
The average value of N1, N2, etc. is always returned. If a variable array is used as one of the parameters, all values in contained in the variable array are averaged in conjunction with any other listed parameters.
If the number of decimals in a set of numbers is different, MINIMUM() adjusts the result to the greater number of decimals.
If a variable array is used as one of the parameters, all values in contained in the variable array are averaged in conjunction with any other listed parameters.
AVERAGE(1.5,2.75,2.0) = 1.42