# Manuals/calci/AVERAGEA

Jump to navigation
Jump to search

**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.

Returns12.5as a result. =AVERAGEA(A1:A5) : Calculates the average of numbers in the range A1 to A5. Text 'Data' is evaluated as 0.

Returns10as a result. =AVERAGEA(A1:A6) : Calculates the average of numbers in the range A1 to A6. Empty cell is ignored.

Returns10as a result. =AVERAGEA(4,6,TRUE) : Calculates the average of numbers and logical value TRUE (1).

Returns3.6666666666666665as a result.