AVG

Calculates the arithmetic mean of the values in a data set.

Syntax:

AVG(list)

Returns the arithmetic mean (average) of the numeric values in the list.

list may be an array, a range of cells, or a comma-separated list of values.

Note that only numeric values are included in the calculation, so that blank elements and text cells do not upset the average.

Example:

AVG(A1:A4)

where the cell values are "Sales", 10.00, 17.00 and 21.00 will return the number 16.00.