Calculates the arithmetic mean[1] (average) of the values in a data set.
Syntax:
AVERAGEA( list )
Returns the arithmetic mean of the 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 numeric values and text cells are included in the calculation - with text being treated as zero - but that blank elements still do not upset the average.
Formula:
AVERAGEA, x = ( i ∑1n xi ) ∕ n
where n is the number of values and xi is the i‑th value.
Example:
AVERAGEA(A1:A4)
where the cell values are "Sales"
, 10.00
, 17.00
and 21.00
will return the number 12.00
.
Revisions:
This function was added in Fireworkz 2.00.