# 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 .
• 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.
```

AVERAGEA