Formulas > =AVERAGE()

How To Use AVERAGE() Function in Google Sheets


Returns the numerical average value in a dataset, ignoring text.

Common questions about the AVERAGE formula include:
- What is the syntax for the AVERAGE formula?
- How can I calculate the average of a particular data set?
- Can I use the AVERAGE formula in a cell range?

The AVERAGE formula can be used appropriately to calculate the average of a list of numbers in a spreadsheet. It can also be used to calculate the average in a given range of cells.

The AVERAGE formula can be commonly mistyped as AVERAGEIF, AVERAGEIFS or sometimes AVERAGE, as all three look similar.

The AVERAGE formula is sometimes used inappropriately if the data set contains non-numeric values. Numeric values are needed to get an accurate average.

Common pitfalls when using the AVERAGE formula include forgetting to include the closing bracket in the formula, not using absolute cell references for ranges, and not accounting for row or column headers when selecting the range of cells.

Common mistakes when using the AVERAGE Formula include selecting more than one cell, using a formula that is designed for a single cell when trying to calculate a range of cells, or expecting the AVERAGE formula to calculate the median or mode of a data set.

Common misconceptions people might have with the AVERAGE Formula include thinking that it will automatically calculate an accurate average with a range, that it can calculate the average of a large data set, or that it can calculate the median or mode of a data set.

How To Actually Use AVERAGE() in Sheets

AVERAGE(value1, [value2, ...])

2Better Sheets Tutorials

One common feature that users often request is the ability to add star ratings to their spreadsheets. While this feature is not built into Google Sheets, it is possible to create a star rating system using emojis and data validation.
What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.

Learn more about the AVERAGE() formula:

Google Sheets - Average, Weighted Average, Average Ifs & Conditional Weighted Average

Learn how to calculate averages in Google Sheets. We'll cover AVERAGE, AVERAGEIFS, Weighted Average & Conditional Weighted Average.

Generate a AVERAGE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.