# Documentation/Calc Functions/AVERAGEA

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

AVERAGEA

## Category:

Statistical Analysis

## Summary:

Returns a real number which is the average of **Number 1**, **Number 2**, … , **Number 255**. It returns the sum of all the numbers divided by the count of the numbers. The value of a text is 0.

## Syntax:

AVERAGEA(**Number 1** [; **Number 2** [; … [; **Number 255**]]])

## Returns:

Returns a real number which is the average of **Number 1**, **Number 2**, … , **Number 255**. It returns the sum of all the numbers divided by the count of the numbers.

## Arguments:

**Number 1**, **Number 2**, ..., **Number 255** are real numbers, references to cells or to cell ranges of numbers.

- Unlike AVERAGE function where you cannot pass text as argument AVERAGEA considers 0 for the text values. For eg =AVERAGE(1.5,"alpha",0,-4.2) gives value error(#VALUE!) but =AVERAGEA(1.5,"alpha",0,-4.2) calculates using "alpha" as 0 and returns -0.675.
- However, both AVERAGE and AVERAGEA returns a name(#NAME?) error if text passed with double quotes. Also both AVERAGE and AVERAGEA considers text value as 0 if a reference to the cell containing that text is passed as an argument.

## Additional details:

None

## Examples:

Formula | Description | Returns |
---|---|---|

=AVERAGEA(A1:A5) where A1,A2,A3,A4,A5 are 1,2,3,4,5 | returns average of 1,2,3,4,5 | 3 |

=AVERAGEA(1.5;-2;0;-4.2) | returns average of 1.5,-2,0,-4.2 | -1.175 |

=AVERAGEA(1.5;"alpha";0;-4.2) | returns average of 1.5,0(for "alpha"),0,-4.2 | -0.675 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

AVERAGEA