Documentation/Calc Functions/AVERAGEA

Function name:
AVERAGEA

Category:
Statistical Analysis

Summary:
Returns a real number which is the average of Number 1, Number 2, …, Number 255. It returns the sum of all the numbers divided by the count of the numbers. The value of a text is 0.

Syntax:
AVERAGEA(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:
Returns a real number which is the average of Number 1, Number 2, …, Number 255. It returns the sum of all the numbers divided by the count of the numbers.

Arguments:
Number 1, Number 2, ..., Number 255 are real numbers, references to cells or to cell ranges of numbers.


 * Unlike AVERAGE function where you cannot pass text as argument AVERAGEA considers 0 for the text values. For eg =AVERAGE(1.5,"alpha",0,-4.2) gives value error(#VALUE!) but =AVERAGEA(1.5,"alpha",0,-4.2) calculates using "alpha" as 0 and returns -0.675.
 * However, both AVERAGE and AVERAGEA returns a name(#NAME?) error if text passed with double quotes. Also both AVERAGE and AVERAGEA considers text value as 0 if a reference to the cell containing that text is passed as an argument.

Additional details:
None

Related LibreOffice functions:
AVERAGE

SUM

COUNT

ODF standard:
Section 6.18.4, part 2

Equivalent Excel functions:
AVERAGEA