How to use AVERAGEA Function in Excel

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:

AVERAGEA Function - How to use AVERAGEA Function in Excel

Syntax:  =AVERAGEA(A2:D2)

Result:

AVERAGEA Function in Excel 1 - How to use AVERAGEA Function in Excel

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:

  1. AVERAGEA evaluates TRUE as 1 and FALSE as zero.
  2. 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.
  3. Arguments that contain TRUE are evaluated as 1 and arguments that contain FALSE are evaluated as 0 (zero).
  4. 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.
  5. The formula will return errors when the arguments are error values or text that cannot be translated into numbers.
  6. 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.
  7. Differences between AVERAGE and AVERAGEA Functions:
    AVERAGEA Function in Excel - How to use AVERAGEA Function in Excel
READ:  How to use T.TEST Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *