AVG

Syntax:

AVG(list)

Returns the arithmetic mean value of the numeric values in the list, which 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 text and blank cells do not upset the average.

Example:

AVG(A1:A4)

where the cell values are "Sales", 10.00, 15.00 and 20.00 will return the number 15.00.