Skip to content

How to Use Excel AVERAGEA Function?

AVERAGEA FunctionPin

AVERAGEA Function: Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. To get the average of a set of values in the spreadsheet, you can use the AVERAGEA function.

In this article, we are going to see how to use the Excel AVERAGEA Function with its syntax, description, and examples. Get an official version of MS Excel from the following link:

Excel AVERAGEA FunctionPin
Excel AVERAGEA Function

Description of AVERAGEA Function

  • It is one of the built-in functions in Microsoft Excel.
  • This function returns the average (arithmetic mean) of a set of input values.
  •  AVERAGEA function evaluates logical values TRUE & FALSE as 1 and 0.


  • Here, you will see the syntax of the AVERAGEA function.
  • To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
  • Once you enter the formula, just click on the Enter button to get the result.

=AVERAGEA(value1, [value2], …)

Arguments Explanation:

  • Value1 – It is the first input number or cell reference.
  • Value2 – It is an optional one. It is the second input number or cell reference.

1) This function ignores the Text, Empty cells, and Special symbols.
2) The arguments can be Numbers, Array, or References that contain numbers.


Let’s see some examples to understand this concept quickly.

  • Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
  • In this screenshot, you can be able to see the input values in Columns B, C, D, and E. The output average values are listed in Column G.
Input RangePin
Input Range
  • Then, we have to apply the above-mentioned formula to get the result, as shown in the following screenshot.
Enter the formulaPin
Enter the formula
  • Finally, we need to click on the Enter button to get the result. And drag down the first cell to fill the remaining cells.
  •  The AVERAGEA function evaluates logical values TRUE & FALSE as 1 and 0.
Input logical valuesPin
Input logical values
  • This function ignores the text, empty cells, and special symbols.
Input Text and Empty cellsPin
Input Text and Empty cells

From the above examples, you can learn how to use the AVERAGEA function in Excel.


In the above article, you can understand the usage of the Excel AVERAGEA Function with its syntax, description, and examples. Share your feedback in the comment section. To learn more about Excel functions, then visit our webpage

Video Tutorial

Use the following video to know how to apply the Excel AVERAGEA function in the spreadsheet with examples.

Read Ahead:


Leave a Reply

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

Share to...