Difference between revisions of "Documentation/How Tos/Calc: AVERAGE function"

Revision as of 07:58, 17 July 2018

AVERAGE

Returns the average of the arguments, ignoring text.

Syntax:

AVERAGE(number1; number2; ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers.

Example:

AVERAGE(2; 6; 4)

returns 4, the average of the three numbers in the list.

AVERAGE(B1:B3)

where cells B1, B2, B3 contain 1, 3, and apple returns 2, the average of 1 and 3. Text is ignored.

Issues:

• Calc assumes that * logical values are 1 (TRUE) and 0 (FALSE). Excel ignores logical values.

• AVERAGEA
• GEOMEAN
• HARMEAN
• MEDIAN
• MODE
• TRIMMEAN
• AVEDEV
• SUM
• COUNT
• DAVERAGE

• Statistical functions

• Functions listed alphabetically
• Functions listed by category