AVERAGEA Function
Calculates the average of a group of supplied values
Calculates the average of a group of supplied values
The AVERAGEA Function in Excel is a statistical function. The function calculates the average of a group of supplied values. It differs from the AVERAGE function, as it evaluates the logical values TRUE and FALSE, and numbers represented as text, whereas AVERAGE just skips these values during calculation. The AVERAGEA function was introduced in MS Excel 2007 and is not available in older versions.
=AVERAGEA(value1, [value2], …)
Where:
Values that are supplied can be numbers, ranges, named ranges, or cell references that contain values. Up to 255 arguments can be supplied.
It is a built-in function which can be used as a worksheet function in Excel. To understand the uses of this function, let’s consider few examples:
With the arguments given below, let’s see how AVERAGEA function is used:
As we can see in the above example:
Let’s see a few more examples to understand the behavior of this function:
As seen in the table above, we can see how each argument behaves when we apply the AVERAGEA function. The function can be supplied as a single number or cell, or as an array of numbers or cells.
The results are below:
Particulars | AVERAGE Function | AVERAGEA Function |
---|---|---|
If we use logical values or text representations of numbers that are typed directly into the list of arguments | They are counted as (TRUE=1, FALSE=0) | They are counted as (TRUE=1, FALSE=0) |
Text that cannot be interpreted as a number and are typed directly into the list of arguments | #VALUE! error | #VALUE! error |
When we entered logical values within arrays or reference arguments | Ignored by this function | They are counted as (TRUE=1, FALSE=0) |
When we enter text that includes empty text "", text representations of numbers, or other text within arrays or reference arguments | Ignored by this function | The function counts it as zero |
Empty cells | Ignored by this function | Ignored by this function |
Click here to download the sample Excel file
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:
To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!