Returns the numerical average value in a dataset. Learn more
In Google Sheets, the AVERAGEA function is used to calculate the average of a range of values, including both numeric and non-numeric data. It treats non-numeric values as 0 while calculating the average.
Here is the syntax for the AVERAGEA function: AVERAGEA(value1, [value2, …])
value1: This is the first value or range of values for which you want to calculate the average. value2 (optional): This is an additional value or range of values that you can include to calculate the average. You can provide multiple values or ranges separated by commas within the parentheses. The AVERAGEA function considers both numeric and non-numeric values in the calculation, treating non-numeric values as 0.
For example, if you have a column of numbers in cells A1 to A5 and some cells with text or empty cells, you can use the AVERAGEA function as follows: =AVERAGEA(A1:A5)
This will return the average of all the values, treating non-numeric values as 0. If any of the cells contain non-numeric data, it will be included in the average calculation as 0.