The Excel AVERAGEA function returns the average of a group of supplied values. Unlike AVERAGE, AVERAGEA will also evaluate the logical values TRUE and FALSE, and numbers represented as text, whereas AVERAGE just skips these values during calculation
Syntax:= AVERAGEA(value1, [value2], …)
The AVERAGEA function syntax has the following arguments:
- Value1, value2, … Value1 is required, subsequent values are optional. 1 to 255 cells, ranges of cells, or values for which you want the average.
Example: Let’s look at some Excel AVERAGEA function examples and explore how to use the AVERAGEA function as a worksheet function in Microsoft Excel:
Syntax: =AVERAGEA(A2:D2)
Result:
Based on the Excel spreadsheet above, the following AVERAGEA examples would return:
Syntax: =AVERAGEA(A3:F3)
Result: 31
Syntax: =AVERAGEA(A4:E4)
Result: 74
Syntax: =AVERAGEA(A5:B5)
Result: 135
Syntax: =AVERAGEA(A6:E6)
Result: 854.2
Syntax: =AVERAGEA(D7:E7)
Result: 0.5
Syntax: =AVERAGEA(A8:E8,90)
Result: 726.8333333
Syntax: =AVERAGEA(A2:D2,A2:A8)
Result: 130.9090909
Note:
- AVERAGEA evaluates TRUE as 1 and FALSE as zero.
- The arguments can be numbers, names, arrays, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE, in a reference.
- Arguments that contain TRUE are evaluated as 1 and arguments that contain FALSE are evaluated as 0 (zero).
- If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.
- The formula will return errors when the arguments are error values or text that cannot be translated into numbers.
- If we do not wish to include logical values and text representations of numbers in a reference as part of the calculation, it would be better to use the AVERAGE function.
- Differences between AVERAGE and AVERAGEA Functions:
