Home Study How to Calculate Average in Google Sheets

How to Calculate Average in Google Sheets

by Frank
Published: Last Updated on


One of the primary formulae you may require in your spreadsheet is to calculate an average. There are many methods to average numbers or cells in Google Sheets.

You may use Google Sheets to keep track of your pupils’ grades or your company’s revenue. When you want to acquire an average of a set of cells, particular values, or a mix of both, you have many methods to choose from. Let’s take a closer look.

Look at a Quick Average

Google Sheets has a few computations that are visible at a glance. This is perfect if you don’t want to put the average of your cells on your sheet but just want to observe it.

Choose the cells that contain the numbers you wish to average. Then, in Google Sheets, look down in the bottom right corner. You’ll see a box with a simple computation, most likely Sum.

View the sum at a glance

When you click the arrow to examine the other alternatives, you’ll see the average.

View the average at a glance

If you want to change your numbers or examine the average for another group of cells, you may retain the average shown in the box by selecting it.

Keep the average displayed

Make use of the Functions Button

You may add the average to your sheet by clicking the Functions icon in the toolbar.

Choose the cells that contain the numbers you wish to average. To examine the available computations, click the arrow next to the Functions icon and choose “Average.”

Average in the Functions button list

You’ll find the temporary location for the function at the bottom of a column or the furthest right of a row. Confirm that the range specified in the formula is accurate, and then hit Enter or Return.

Average formula using the Functions button

The average formula is then automatically entered into the cell for you.

Keep the average on the sheet

Manually Enter the Function

Perhaps you’d want to calculate the average of nonadjacent cells, numbers, or a mix of cells and numbers. In this instance, manually inputting the AVERAGE function is your best bet. This offers you the freedom to modify the formula as needed.

In Google Sheets, the function syntax is AVERAGE(value1, value2,…), where value1 is necessary and value2 is optional.

Choose the cell in which you wish to see the average. For this first example, we’ll average two nonadjacent cell groups, B2 through B12 and E2 through E12. Enter the formula below, substituting the cell references with your own.


Average function for groups of cells

If the numbers you wish to average do not exist inside cells, just insert them into the formula to get their average.


Average function for numbers

In the formula, you may also mix cells and numbers. We’ll use the following to average numbers 10 and 15, the cell range B2 through B12, and cell E12.


Average function for groups of cells plus numbers

You may choose the best solution for calculating an average in Google Sheets based on your requirements.

Also, learn how to multiply integers in Google Sheets and how to utilize the MEDIAN function.

You may also like

Navhow is dedicated to teaching people all over the world how to do anything.



The Best How-To Newsletter Anywhere

©2022 Navhow, All Right Reserved