# Learn =AVERAGEA() function – How to use with examples

The AVERAGEA function is a built-in function in Excel that calculates the average (arithmetic mean) of the values in a range of cells, including text and logical values, in addition to numeric values.

### Usage of AVERAGEA Function in Excel

The AVERAGEA function can be used in any situation where you need to calculate the average of a range of cells that may contain non-numeric values, such as text or logical values. It is useful in data analysis and statistics.

Syntax: =AVERAGEA(value1, [value2], …)

### Example of AVERAGEA() function in Formula:

1. =AVERAGEA(10, 20, 30) returns 20.
2. =AVERAGEA(“Red”, “Green”, “Blue”) returns 0.
3. =AVERAGEA(5, “Red”, 15, “Green”) returns 10.
4. =AVERAGEA(TRUE, FALSE, TRUE) returns 0.6667.
5. =AVERAGEA({10, 20, 30, “Red”, TRUE, FALSE}) returns 10.
6. =AVERAGEA({1,2,3,4},TRUE, {“a”,”b”,”c”,”d”},FALSE) returns 1.25
7. =AVERAGEA(B2:B10) returns the average of values in cells B2 to B10
8. =AVERAGEA(B2,B5,B7,B9) returns the average of values in cells B2, B5, B7, and B9
9. =AVERAGEA(B2:B10,D2:D10) returns the average of values in cells B2 to B10 and D2 to D10
10. =AVERAGEA(A1:A10) returns the average of values in cells A1 to A10

### List of Similar Functions:

1. =AVERAGE(): This function calculates the average of numeric values in a range of cells.
2. =AVERAGEIF(): This function calculates the average of a range of cells based on a specific condition.
3. =AVERAGEIFS(): This function calculates the average of a range of cells based on multiple conditions.
4. =MEDIAN(): This function calculates the median (middle) value in a range of cells.
5. =MODE(): This function calculates the mode (most frequently occurring) value in a range of cells.
6. =STDEV(): This function calculates the standard deviation of a range of cells.
7. =SUM(): This function calculates the sum of a range of cells.
8. =COUNT(): This function counts the number of cells that contain a number.
9. =COUNTA(): This function counts the number of cells that are not empty.

### FAQs:

Can AVERAGEA function handle text and logical values?

Yes, the AVERAGEA function can handle text and logical values in addition to numeric values.

What happens if I use AVERAGEA function on a range of cells that contain errors?

The AVERAGEA function treats errors as numeric values and includes them in the calculation.

How do I specify a range of cells for the AVERAGEA function?

You can specify a range of cells by using cell references (e.g., A1:B10) or by using the colon operator (e.g., A1:A10).

Can I use AVERAGEA function with multiple ranges?

Yes, you can use the AVERAGEA function with multiple ranges by separating the ranges with commas (e.g., =AVERAGEA(A1:A10,B1:B10)).

Is AVERAGEA function case-sensitive?

No, the AVERAGEA function is not case-sensitive.