Better Sheets

Formulas > =AVERAGE()

How to Use AVERAGE() in Google Sheets

Description

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

How To Actually Use AVERAGE() in Sheets

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

Try AVERAGE yourself

Use the AVERAGE formula to calculate the average sales from the range B2:B10. The correct answer must return the average value of the sales data.

Your formula

Hints (2)

Locale Separator ,

Official Docs

6 Better Sheets Tutorials

Ken Asks: Can We Add Star Ratings?

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.

Beginner

AVERAGE() SWITCH() VLOOKUP()

Use Min and Max for More Average Averages

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.

Beginner

AVERAGE() MAX() MEDIAN() MIN()

Create a Branded Lead Magnet from Qualitative Data

Find out how to turn some data you can copy/paste from the web into a branded lead magnet for yourself.

Check out Josh's Tweet about the sheet.
and check out his Podia.

The video shows the importance of adding personal touches to a Google Sheet to connect better with users. It explains how to analyze the sheet's data to find trends and best practices for website content. Lastly, it discusses ways to share the sheet widely while still giving credit to its creator.

Intermediate

AVERAGE() COUNTA() COUNTIF() FIND() HYPERLINK() +7 more

Build Your Own Net Promoter Score (NPS) Survey on a Web Site

Create an embeddable NPS system on a web page.

Advanced

AVERAGE() DCOUNTA() ROUND()

Add NPS to Your Google Site

Create buttons on your Google Site to get an NPS, or Net Promoter Score directly to a Google Sheet.

Intermediate

AVERAGE()

Automate Help Desk Ticket Closing

Create a simple automated help desk ticketing system.

Create tickets
Closed dropdown
Calculate time to close
Create dashboard

Advanced

AVERAGE() COUNTA() COUNTIF() FILTER() IF()

Transcript-matched member videos for AVERAGE(). Click through to watch.

Browse more tutorials

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sh...

Data validation Beginner

How to Iterate Counting Blank Cells in Google Sheets

Count different types of blank cells. Cells with nothing in them.

Intermediate

ARRAYFORMULA() IF() ISBLANK() MAX()

Unlock these tutorials

Learn more about the AVERAGE() formula:

Generate a AVERAGE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses AVERAGE(). 2 free AI generations, no signup. Members get unlimited use.

Generate a AVERAGE() formula

How to Use AVERAGE() in Google Sheets

Try AVERAGE yourself

Ken Asks: Can We Add Star Ratings?

Use Min and Max for More Average Averages

Create a Branded Lead Magnet from Qualitative Data

Build Your Own Net Promoter Score (NPS) Survey on a Web Site

Add NPS to Your Google Site

Automate Help Desk Ticket Closing

More related tutorials

Google Sheet Basics - The Absolute Basics

Hardest Formula: SumIF | Addition Based on Dates / Values

Magical Things You Can do with Checkboxes in Google Sheets

How to Iterate Counting Blank Cells in Google Sheets