AVERAGEA
TheAVERAGEA
function calculates the average (arithmetic mean) of the values specified in the input. It differs from the AVERAGE
function in that it can handle nonnumeric values, treating them as 0. This function is commonly used to calculate the average of a range of cells that may contain both numeric and nonnumeric values.
 How to use
AVERAGEA
formula?  Examples of using
AVERAGEA
formula AVERAGEA
formula not working? Similar formulas to
AVERAGEA
Usage
Use the AVERAGEA
formula with the syntax shown below, it has 1 required parameter:
 value1, [value2, ...] (required):
The values to include in the calculation of the average. If a value is not numeric, it is treated as 0.
Examples
Here are a few example use cases that explain how to use theAVERAGEA
formula in Google Sheets.
Calculate the average of a range that contains both numbers and text
When calculating the average of a range that contains both numeric and nonnumeric values, the AVERAGEA
function can include the nonnumeric values as 0s in the calculation.
Calculate the average of a range that may contain blank cells
The AVERAGEA
function can handle blank cells in a range and treat them as 0s in the calculation of the average.
Calculate the average of a range that includes errors
If a range of cells includes an error value, such as #DIV/0!, the AVERAGEA
function treats the error as 0 in the calculation of the average.
Common Mistakes
AVERAGEA
not working? Here are some common mistakes people make when using the AVERAGEA
Google Sheets Formula:
Forgetting to input values
If no values are input, AVERAGEA will return a zero instead of an error
Misunderstanding what AVERAGEA includes
AVERAGEA includes numbers, logical values, and text representations of numbers, but excludes empty cells, Boolean values or text
Not understanding the difference between AVERAGE and AVERAGEA
AVERAGEA includes nonnumeric values, while AVERAGE calculates the average only for numeric values
Related Formulas
The following functions are similar to AVERAGEA
or are often used with it in a formula:

AVERAGE
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

AVERAGEIF
The
AVERAGEIF
function calculates the average of a range of cells that meet a specified criteria. It is commonly used when working with large datasets to quickly calculate the average of a subset of data. The function takes a range of cells to evaluate (criteria_range), a string or value to compare against (criterion), and an optional range of cells to average (average_range). If the average_range is not specified, the function will use the same range as the criteria_range. 
AVERAGEIFS
The
AVERAGEIFS
formula calculates the average of a range of cells that meet multiple criteria. It is most commonly used to find the average of a range of values that meet specific conditions. The formula takes one required argument (average_range) and any number of optional argument pairs (criteria_range, criterion). 
MEDIAN
The
MEDIAN
function returns the median (middle) value of a set of numbers. It is commonly used to find the middle value in a range of data points. If the number of data points is even, it returns the average of the two middle values. This function can be useful in statistical analysis and data visualization. 
MODE
The MODE formula in Google Sheets returns the most frequently occurring value in a dataset. It is commonly used in statistical analysis to identify the value that occurs most frequently in a set of data. The formula requires at least one input value, but can accept multiple values to include in the analysis.
Learn More
You can learn more about the AVERAGEA
Google Sheets function on Google Support.