Average

Syntax

Average(Values1, ...)

Values1, Values2, …, ValuesN. The range of cells, for which the average should be calculated.

NOTE. Both value itself or address of the cell (cell range) containing this value can be specified as the parameter.

It returns the average of an array of cells.

If the Check References to Empty Cells checkbox is not selected in report formula settings, and:

A cell range, for which it is required to calculate average value, entirely consists of empty values, the function returns the "#NUMBER!" value.
A cell range, for which it is required to calculate average value, contains several empty values, the function is calculated without taking into account empty values.

If the Check References to Empty Cells checkbox is selected, empty values in cells are considered as zero ones.

Formula	Result	Description
=Average(A1, A2, A3)	4,2333	Average value of the array in the A1, A2, A3 cells. The A1 cell contains the 1.32 number, the A2 cell contains the 4.53 number, the A3 cell contains the 6.85 number.
=Average(1.15, 2.75, 3.81)	2,5700	Average value of the specified array of values.