**Home ► Excel Functions ► Excel AVERAGEA Function**

**What is the use of Excel AVERAGEA Function?**

Use **Excel AVERAGEA Function ** to average numbers, logical values & numbers which are stored as a text. In simple words, It will calculate average for the number, logical values (TRUE or FALSE) & number which are stored as text(in double quotes).

**Syntax for Excel AVERAGEA Function**

**AVERAGEA(value1,value2,…)**

**value1 ** A value which is a number, a logical value or a number which is stored as a text.** **[Required]

**value2 **A value which is a number, a logical value or a number which is stored as a text. [Optional]

**More Information on Excel AVERAGEA Function**

- The difference between
**AVERAGE**& AVERAGEA is that AVERAGEA also considers text & logical values while calculating the average. - Logical value
**TRUE**will consider as 1 &**FALSE**will consider as 0. - If you enter a text directly into the function it will return #VALUE! & if you refer a cell which has a text, it will treat that text as 0.
- If you enter a number directly into the function using double quotation marks, it will ignore that quotation marks & take it as a number. But if you refer to a cell which has a number formatted as text, it will consider that argument as 0. You can change the number format in that case.
- If any of the specified arguments is an error, it will return an error in the result.

**Examples to understand Excel AVERAGEA Function**

In above example, I have used arguments with different values.

- A cell which has text in it is considered as 0.
- A cell which has FALSE in it is considered as 0 & TRUE is considered as 1.
- All cells which have numbers in it as taken as their actual numbers.

And, value returned by the function is 10.17 which is **“(0+0+1+10+20+30)/6”.**

In above example, I have inserted values directly into the function.

- A number which I have inserted using double quotation marks, excel take it as a number.
**TRUE**is considered as 1 &**FALSE**is considered as 0.

You can use AVERAGE Function where you have values other than numbers in your data.

**Download Sample File**

**Conclusion**

Use **Excel AVERAGEA Function** to calculate an average of numbers, text & logical values. Learn more about AVERAGEA from **here**.