AVERAGE In Google Sheets

What Is AVERAGE Function In Google Sheets?

AVERAGE function in Google sheets, as the name suggests, is used to find the average of some values. It is a default function available in Microsoft Excel and Google Sheets. Just like SUM function, users also use AVERAGE function in Google sheets. It is an inbuilt function used to find the result of mean of the given values.

For example, consider the below table showing region in column A and values in column B, respectively.

AVERAGE in Google Sheets - Definition Example - 1

Now, let us learn how to find the average of values in Google sheets using AVERAGE function. To begin with, insert the AVERAGE function and select the values. So, the complete formula is =AVERAGE(B2:B5) and press Enter key. We will be able to see the result as shown in the below image.

AVERAGE in Google Sheets - Definition Example - 2

Likewise, we can find the average of mean using AVERAGE function in Google sheets.

In this article, let us learn how to use AVERAGE function in Google sheets with detailed examples.

AVERAGE function in Google sheets is a default inbuilt function used to find the average or mean of certain data.
The syntax of AVERAGE function in Google sheets is =AVERAGE(value1,[value2,…]) where Value1 shows the values used to find the average. It is a mandatory argument.
We can find the average of values for a continuous cell range or exclude specific cells by selecting the cell reference and cell range.
Remember, we need to make sure the data contains only numeric values as AVERAGE function does not read non-numeric values.

AVERAGE() Google Sheets Function Formula

The formula or syntax of AVERAGE function is

=AVERAGE(value1,[value2,…])

where,

Value1 is the mandatory argument showing the values used to find the average.

How To Use AVERAGE In Google Sheets?

We can use AVERAGE in Google sheets function in two methods. They are:

Select the AVERAGE function under Insert tab
Manually enter the AVERAGE function

Method #1 – Select The AVERAGE Function Under Insert Tab

The steps are:

To begin with, we need to insert the data in spreadsheet. Next, select the cell where we want to find the result.
Now, select the Insert tab and click on Function option. Next, click on Statistical option and choose AVERAGE function.
We will be able to see the =AVERAGE function in the selected cell. Next, select the values we want to include in the formula.
Press Enter key.
We will be able to use the AVERAGE function in Google sheets.

Likewise, we can find the average or mean in Google sheets.

Method #2 – Manually Enter The AVERAGE Function

The steps are:

Step 1: To begin with, we need to insert the data in spreadsheet. Next, select the cell where we want to find the result.

Step 2: Now, type =A or =AVERAGE function. In the pop up option, we will be able to see AVERAGE option.

Step 3: Click on the AVERAGE function to insert the AVERAGE function formula in Google sheets.

Step 4: Next, select the values we want to include in the formula.

Step 5: Press Enter key.

We will be able to use the AVERAGE function.

Likewise, we can find the average or mean in Google sheets.

Examples

Now, let us learn how to use AVERAGE function with the following examples.

Basic Example

For example, consider the below table showing name and grade in columns A and B, respectively.

Now, let us find the average of grades in column B, using AVERAGE function.

The steps are:

Step 1: To begin with, we need to enter the data in the spreadsheet. In this example, the data is available in the cell range A1:B8. Next, we need to select the cell range or cells for which we want to find the average. In this example, we need to select the cell range B2:B7.

Step 2: Next, insert the AVERAGE function formula.

So, the complete formula is =AVERAGE(B2:B7)

Step 3: Press Enter key.

Now, we will be able to find the average, as shown in the below image.

Likewise, we can use the AVERAGE function to find the average.

Example #1 – Analyze Employee Grades

For example, consider the below table showing name and grade in columns A and B, respectively.

Now, let us find the average of grades in column B, using AVERAGE function.

The steps are:

Step 1: To begin with, we need to enter the data in the spreadsheet. In this example, the data is available in the cell range A1:B8. Next, we need to select the cell range or cells for which we want to find the average. In this example, we need to select the cell range B2:B7.

Step 2: Next, insert the AVERAGE function in Google sheets formula.

So, the complete formula is =AVERAGE(B2:B7)

Step 3: Press Enter key.

Now, we will be able to find the average, as shown in the below image.

AVERAGE Function in Google Sheets - Example 1 - Step 3

Likewise, we can use the AVERAGE function to find the average.

Example #2 – Conditional Formatting Based On AVERAGE Function In Google Sheets

For example, consider the below table showing product and price in columns A and B, respectively.

Now, let us use the conditional formatting based on AVERAGE function in Google sheets.

The steps are:

Step 1: To begin with, we need to enter the data in the spreadsheet. In this example, the data is available in the cell range A1:B8. Next, we need to select the cell range or cells for which we want to find the average. In this example, we need to select the cell range B2:B7.

Step 2: Next, click on Format and select Conditional formatting.

Step 3: The Conditional formatting window opens up. Here, select Greater than under the Format cells if option and insert the AVERAGE function formula.

So, the complete formula is =AVERAGE(B2:B7).

Step 3: Press Enter key.

Now, we will be able to find the average, as shown in the below image.

AVERAGE Function in Google Sheets - Example 2 - Step 3

Likewise, we can use the AVERAGE function to find the average.

Example #3 – Exclude Specific Cells From Calculation

For example, consider the below table showing item and price in columns A and B, respectively.

Now, let us find the average of prices in column B, using AVERAGE function.

The steps are:

Step 1: To begin with, we need to enter the data in the spreadsheet. In this example, the data is available in the cell range A1:B8. Next, we need to select the cell range or cells for which we want to find the average. In this example, we need to select the cell range B2:B7.

Now, assume we want to find the average of items excluding Mouse and keyboard.

Step 2: Next, insert the AVERAGE function formula.

So, the complete formula is =AVERAGE(B2,B5:B7)

Step 3: Press Enter key.

Now, we will be able to find the average in Google sheets, as shown in the below image.

Google Sheets AVERAGE Function - Example 3 - Step 3

Likewise, we can use the AVERAGE function in Google sheets to find the average, excluding specific cells in the data.

Important Things To Note

AVERAGE function in Google sheets is a commonly used function in Google sheets.
We need to make sure to add IF function or alternatively use AVERAGEIF function if there is any condition with which we want to find average.
Users can find the result of AVERAGE using cell range or values.

Frequently Asked Questions (FAQs)

1. Explain the use of AVERAGE function in Google sheets with detailed example.

For example, consider the below table showing sample and data in columns A and B, respectively.

We can find the average of values using AVERAGE in Google sheets function.

The steps are:

• Step 1: To begin with, we need to enter the data in the spreadsheet. In this example, the data is available in the cell range A1:B6. Next, we need to select the cell range or cells for which we want to find the average. In this example, we need to select the cell range B2:B5.

• Step 2: Next, insert the AVERAGE function formula.
So, the complete formula is =AVERAGE(B2:B5)

• Step 3: Press Enter key.
We will be able to find the average in Google sheets, as shown in the below image.

Likewise, we can use the AVERAGE function in Google sheets to find the average.

2. What is the difference between AVERAGE and AVERAGEIF function in Google sheets?

The difference between AVERAGE and AVERAGEIF function are:
• AVERAGE function is used to find the average of values in the given data.
• AVERAGEIF function finds the average of values with a condition.

3. Why AVERAGE function is not working in Google sheets?

AVERAGE function in Google sheets may not work,
• When the data contains non-numeric values such as text, symbols, punctuation marks etc.,
• When the data is not related with the cell range

Download Template

This article must help understand AVERAGE In Google Sheets with its formulas and examples. You can download the template here to use it instantly.

AVERAGE In Google Sheets Download

AVERAGE In Google Sheets