Hamilton Ideas

Jul 09, 2026 RAW
Article

How to Calculate Average in Google Sheets

Ever found yourself poring over rows and columns of data in Google Sheets, wishing you could calculate averages with just a few clicks? You're not alone. Google Sheets offers a simple yet powerful function to compute averages, making your data analysis tasks a breeze. Let's dive into how to create an average in Google Sheets.

How to Calculate Average in Google Sheets
How to Calculate Average in Google Sheets

Before we get started, ensure you're familiar with the basic layout of Google Sheets. You'll need to know how to navigate cells, which are identified by their row and column numbers (e.g., A1, B2, C3). Now, let's explore the AVERAGE function and its applications.

2 Easy Ways to Calculate Weighted Average in Google Sheets
2 Easy Ways to Calculate Weighted Average in Google Sheets

Understanding the AVERAGE Function

The AVERAGE function in Google Sheets calculates the average (mean) of a range of cells containing numbers. It's a lifesaver when you need to quickly summarize data or identify trends. Let's break down its syntax and usage.

How to Create a Histogram in Google Sheets
How to Create a Histogram in Google Sheets

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

Here, 'value1' is required and represents the first cell or range of cells you want to average. You can add more values (up to 255) separated by commas to include in the calculation. If you're averaging a range of cells, you can use the range reference directly (e.g., A1:A10).

How to Use the AVERAGEIF Function in Google Sheets
How to Use the AVERAGEIF Function in Google Sheets

Calculating the Average of a Single Column or Row

To calculate the average of a single column or row, simply enter the range reference into the AVERAGE function. For example, if your data starts from A1 and spans 10 rows, use the formula:

=AVERAGE(A1:A10)

Google Sheets Budget Tutorial: Master Your Finances Easily!
Google Sheets Budget Tutorial: Master Your Finances Easily!

This will return the average of the numbers in cells A1 through A10.

Calculating the Average of Multiple Columns or Rows

You can also calculate the average of multiple columns or rows by listing their range references in the AVERAGE function. Suppose you have data in columns A and B, and you want to find their average. Use the formula:

a screenshot of a spreadsheet with multiple columns and numbers on the screen
a screenshot of a spreadsheet with multiple columns and numbers on the screen

=AVERAGE(A1:B10)

This will return the average of the numbers in cells A1 through B10.

How to Create a Cumulative Sum Chart in Google Sheets
How to Create a Cumulative Sum Chart in Google Sheets
the google spreadsheet has been updated to help students learn how to use them
the google spreadsheet has been updated to help students learn how to use them
How to Calculate Running Total in Google Sheets
How to Calculate Running Total in Google Sheets
How to use Google Sheets: A beginner's guide | Zapier
How to use Google Sheets: A beginner's guide | Zapier
Master Google Sheets Dynamic Named Ranges
Master Google Sheets Dynamic Named Ranges
How To Make A Budget On Google Sheets in 2026 (+ Examples)
How To Make A Budget On Google Sheets in 2026 (+ Examples)
the google spreadsheet dashboard is shown in this screenshot
the google spreadsheet dashboard is shown in this screenshot
How to Calculate Age in Google Sheets - ModernSchoolBus.com
How to Calculate Age in Google Sheets - ModernSchoolBus.com
How to Make a Histogram in Google Sheets
How to Make a Histogram in Google Sheets
Creating a Search Box in Google Sheets Using Query: Step-by-Step Guide [2026]
Creating a Search Box in Google Sheets Using Query: Step-by-Step Guide [2026]
How to Find Average of Data in Google Sheets
How to Find Average of Data in Google Sheets
Basic Formatting in Google Sheets
Basic Formatting in Google Sheets
How to Count Unique Values In Google Sheets
How to Count Unique Values In Google Sheets
GOOGLE SHEETS: Spreadsheet Formulas & Averages a SUMMER SCHOOL Grade Sheet
GOOGLE SHEETS: Spreadsheet Formulas & Averages a SUMMER SCHOOL Grade Sheet
a printable budget sheet with the text 50 / 30 / 20 budget
a printable budget sheet with the text 50 / 30 / 20 budget
How to Create a Data Entry Form in Google Sheets
How to Create a Data Entry Form in Google Sheets
Filter Has Mismatched Range Sizes in Google Sheets
Filter Has Mismatched Range Sizes in Google Sheets
Google Sheets Tutorial: How to Open a Spreadsheet
Google Sheets Tutorial: How to Open a Spreadsheet
3 Ways to Assign Google Sheets Resources
3 Ways to Assign Google Sheets Resources
How to create and customize charts in Google Sheets (Quick version)
How to create and customize charts in Google Sheets (Quick version)

Ignoring Errors and Blank Cells

In real-world data, you might encounter errors (like #DIV/0!) or blank cells. By default, the AVERAGE function includes these in its calculation, which can skew your results. Let's learn how to exclude them.

To ignore errors, wrap the range reference with the IFERROR function. For example:

=AVERAGE(IFERROR(A1:A10, 0))

This will treat errors as zero, allowing the AVERAGE function to calculate the average correctly.

Ignoring Blank Cells

To ignore blank cells, use the ISBLANK function in combination with the IF function. Here's an example:

=AVERAGE(IF(ISBLANK(A1:A10), "", A1:A10))

This will exclude blank cells from the average calculation.

Using AVERAGEIF and AVERAGEIFS for Conditional Averaging

Sometimes, you might want to calculate the average based on certain conditions. This is where the AVERAGEIF and AVERAGEIFS functions come in handy.

The AVERAGEIF function calculates the average of cells that meet a specific criterion. Its syntax is:

AVERAGEIF(range, criterion)

For example, to find the average of cells in A1:A10 that are greater than 50, use:

=AVERAGEIF(A1:A10, ">50")

The AVERAGEIFS function is more versatile, as it allows you to specify multiple criteria. Its syntax is:

AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2], ...)

For instance, to find the average of cells in A1:A10 that are greater than 50 and less than 100, use:

=AVERAGEIFS(A1:A10, A1:A10, ">50", A1:A10, "<100")

And there you have it! You're now well-equipped to calculate averages in Google Sheets with ease. Whether you're analyzing sales data, tracking project progress, or crunching numbers for a report, the AVERAGE function and its variants will become your go-to tools. Happy calculating!