## How to use the AVERAGEA function

*Article updated on February 27, 2018*

The AVERAGEA function returns the average of a group of values. Text and boolean value FALSE evaluates to 0. TRUE to 1.

Formula in cell D3:

0 + 1 + 2 + 1 + 0 = 4/5 = 0.8

### Excel Function Syntax

AVERAGEA(*value1*, *[value2]*, ...)

### Arguments

value1 |
Required. Values for which you want to calculate the average. |

[value2] |
Optional. Up to 254 additional arguments. |

### Comments

The AVERAGEA function evaluates 1 for boolean value TRUE and 0 (zero) for FALSE. Text values and formulas that return nothing "" evaluate to 0 (zero).

This table shows the difference between AVERAGEA and AVERAGE functions.

Values | AVERAGEA | AVERAGE |
---|---|---|

Text values | 0 | Ignored |

Empty cells | Ignored | Ignored |

TRUE | 1 | Ignored |

FALSE | 0 | Ignored |

### Functions in 'Statistical'

The AVERAGEA function function is one of many functions in the 'Statistical' category.