Documentation/Calc Functions/AVERAGE

Function name:
AVERAGE

Category:
Statistical Analysis

Summary:
Returns the average of the arguments.

Syntax:
AVERAGE(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.


 * If any of the arguments contain text value either being passed directly or with double quotes then the function returns a name(#NAME?) error or a simple error value(Err:504), respectively.
 * If a reference to a cell containing text is passed as an argument then the function calculates average absolute deviation considering text value as 0.

Additional details:
None

Related LibreOffice functions:
SUM

COUNT

ODF standard:
Section 6.18.3, part 2

Equivalent Excel functions:
AVERAGE