Documentation/Calc Functions/AVERAGEA

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

AVERAGEA

Category:

Statistical Analysis

Summary:

Returns the average of the arguments.

Syntax:

AVERAGEA(Value1; Value2; ...; Value30)

Returns:

Arguments:

Value1, Value2, ..., Value30 are values or ranges. Text has the value of 0.

Additional details:

The value of a text is 0.

Examples:

=AVERAGEA(A1:A50)

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: