AVERAGEA

Returns the numerical average value in a dataset. Learn more

Video field
Statistical

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.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!