How to use AVERAGEA Google Sheets formula?

The syntax for the AVERAGEA formula is =AVERAGEA(value1, [value2, ...]), it has 1 required parameter.

Why is AVERAGEA Google Sheets formula not working?

One common reason the AVERAGEA formula may not be working is due to forgetting to input values. If no values are input, AVERAGEA will return a zero instead of an error

AVERAGEA

The AVERAGEA function calculates the average (arithmetic mean) of the values specified in the input. It differs from the AVERAGE function in that it can handle non-numeric 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 non-numeric 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:

=AVERAGEA(value1, [value2, ...])

Parameters:

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 the AVERAGEA 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 non-numeric values, the AVERAGEA function can include the non-numeric 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 non-numeric values, while AVERAGE calculates the average only for numeric values

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.