AVERAGEA function calculates the average of a set of numbers, including text, logical values, and empty cells, while ignoring cells containing errors. It’s a versatile function commonly used in Excel for statistical analysis and data processing.
Syntax
AVERAGEA(value1, [value2], …)
Arguments
| value1 | The first value or reference to a range of cells containing numbers, text, logical values, or empty cells to include in the average calculation. |
| [value2] | (Optional) Additional values or references to include in the average calculation. You can include up to 255 arguments in total. |
How to use
The AVERAGEA function is straightforward to use. You can use it to calculate the average of various data types. Here are some examples:
|
1 |
=AVERAGEA(1, 2, 3, 4, 5) |
This formula calculates the average of the numbers 1, 2, 3, 4, and 5, resulting in an average of 3.0.
|
1 |
=AVERAGEA("apple", "banana", "cherry") |
Here, the function calculates the average of the text values “apple,” “banana,” and “cherry.” Since these are non-numeric values, the function treats them as 0, resulting in an average of 0.
|
1 |
=AVERAGEA(TRUE, FALSE, TRUE, FALSE) |
This example uses logical values (TRUE and FALSE) to calculate the average. TRUE is treated as 1, and FALSE as 0. The average of these values is 0.5.
|
1 |
=AVERAGEA(10, "apple", 20, "banana", 30) |
Even if you mix different data types, the AVERAGEA function can still calculate the average. It considers the numeric values and treats text as 0. In this case, the average is 12.
It’s important to note that the AVERAGEA function ignores errors, so if there are error values like #DIV/0! or #N/A in the range, they won’t affect the average calculation.