Calculates the arithmetic mean[1] (average) of the values in a data set.
Syntax:
AVG( list )
Returns the arithmetic mean of the numeric values in the list.
list may be a range of cells, an array, or a comma-separated list of values (which may contain cell references and also ranges of cells as one or more of its elements).
Note that only numeric values are included in the calculation, so that blank elements and text cells do not upset the average.
Formula:
AVG, x = ( i ∑1n xi ) ∕ n
where n is the number of values and xi is the i‑th value.
Example:
AVG(A1:A4)
where the cell values are "Sales"
, 10.00
, 17.00
and 21.00
will return the number 16.00
.
Revisions:
Starting with 2.00, this function will accept date / time values.