Documentation/Calc Functions/AVERAGEA

From The Document Foundation Wiki
Jump to navigation Jump to search


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

Examples:

Formula Description Returns
=AVERAGEA(A1:A5) where A1,A2,A3,A4,A5 are 1,2,3,4,5 returns average of 1,2,3,4,5 3
=AVERAGEA(1.5;-2;0;-4.2) returns average of 1.5,-2,0,-4.2 -1.175
=AVERAGEA(1.5;"alpha";0;-4.2) returns average of 1.5,0(for "alpha"),0,-4.2 -0.675

Related LibreOffice functions:

AVERAGE

SUM

COUNT

ODF standard:

Section 6.18.4, part 2

Equivalent Excel functions:

AVERAGEA