Manuals/calci/AVERAGEA

AVERAGEA ()

• Parameters are values or range of cells containing values.

• • AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.

Description

AVERAGEA()

• Arithmetic mean is the sum of values divided by the number of values.
• Arguments can be numbers, names, arrays, or range of cells containing numbers, logical values etc.
• If logical values and text representation of numbers is entered directly as a part of argument, it is counted.
• Logical value TRUE is evaluated as 1 and logical value FALSE is evaluated as 0.
• Empty text ("") is ignored. Cells containing text are evaluated as 0.
• For invalid argument values, Calci displays error message.
• AVERAGE() function can be used if arguments do not contain text or logical values.

ZOS

• The syntax is to calculate AVERAGEA in ZOS is $AVERAGEA()$.
  • Parameters are any numbers,including text, and logical values.
• For e.g.,AVERAGEA(20..35,TRUE)
• AVERAGEA(-100..-75,FALSE)

Examples

20
15
5
10
Data

=AVERAGEA(A1:A4) : Calculates the average of numbers in the range A1 to A4. 
Returns 12.5 as a result.
=AVERAGEA(A1:A5) : Calculates the average of numbers in the range A1 to A5. Text 'Data' is evaluated as 0. 
Returns 10 as a result.
=AVERAGEA(A1:A6) : Calculates the average of numbers in the range A1 to A6. Empty cell is ignored. 
Returns 10 as a result.
=AVERAGEA(4,6,TRUE) : Calculates the average of numbers and logical value TRUE (1). 
Returns 3.6666666666666665 as a result.

Related Videos

AVERAGEA

See Also

• AVERAGE

References

• Average
• Arithmetic Mean

• List of Main Z Functions

• Z3 home