Google Sheets AVERAGEIF Function

What Is Google Sheets AVERAGEIF Function?

AVERAGEIF function in Google sheets, as the name suggests, helps users find the average of a given data with a condition or criterion. It is a default function available in both Excel and Google sheets.

Similar to AVERAGE function in Google sheets, this function also helps users find the average of data set but with a condition such as text, number, date, comparison operators such as greater than, lesser than, greater than or equal to, lesser than or equal to, equal to or not equal to in Google sheets.

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

Now, let us learn how to use AVERAGEIF function in Google sheets with the following steps.

To begin with, select the cell B8 and insert the AVERAGEIF function in Google sheets with the formula, =AVERAGEIF(A2:A6,”A”,B2:B6) and press Enter key.

We will be able to see the result in cell B8, as shown in the below image.

Likewise, we can use AVERAGEIF function in Google sheets.

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

AVERAGE() Google Sheets Formula

The formula or syntax of AVERAGEIF function in Google sheets is =AVERAGEIF(criteria_range,criterion,[average_range])

where

1. Criteria range is the cell range showing data which can be used as criterions.
2. Criterion is the condition which we want to check in the data
3. Average range is the data showing values for which we need to find the average.

How To Use AVERAGEIF Function in Google Sheets?

We can use WORKDAY Google sheets function in two different ways.

They are:

• Inserting the formula from the tab
• Manually entering the function

Method #1 – Inserting The Formula from The Tab

Step 1: To begin with, we need to open the Google sheets spreadsheet and insert the data.

Step 2: Next, select the cell where we want to find the result. C0lick on Insert tab.

Step 3: Next, select Function option.

And then, click on Statistical in the drop-down options.

Step 4: Scroll down and click on the AVERAGEIF option.

We will be able to see the function in the cell. Now, we can insert the cell range and find the average with condition or criterion using AVERAGEIF function.

Method #2 – Manually Entering The Function

Step 1: To begin with, we need to open the Google sheets spreadsheet. Insert the data.

Step 2: Next, select the cell where we want to find the result and type =AVERAGEIF( and select the

arguments.

Step 3: Alternatively, we can also type =A and select AVERAGEIF function from the suggestions

shown in Google sheets function.

Likewise, we can insert AVERAGEIF function.

Examples

Let us learn how to use AVERAGEIF function with the help of following examples.

Example #1 – AVERAGEIF Function With Text

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

Now, let us learn how to use the AVERAGEIF function to find the average with text as condition.

The steps are:

Step 1: To begin with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:B10. Next, select the cell where we want to find the result. In this example, we need to select the cell B10.

Step 2: Next, insert the AVERAGEIF function and select the cell range.

So, the complete formula is =AVERAGEIF(A2:A9,”North”,B2:B9)

Step 3: Press Enter key.

We will be able to see the result in cell B10, as shown in the below image.

Likewise, we can find the average of values with text condition as ‘NORTH’.

Example #2 – AVERAGEIF Function With Numbers

For example, consider the below table showing subject, test and marks in columns A, B and C, respectively.

Now, let us learn how to use the AVERAGEIF function to find the average with numbers as condition.

The steps are:

Step 1: To begin with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:C10. Next, select the cell where we want to find the result. In this example, we need to select the cell C10.

Step 2: Next, insert the AVAERAGEIF function and select the cell range.

So, the complete formula is =AVERAGEIF(B2:B9,”1″,C2:C9)

Step 3: Press Enter key.

We will be able to see the result in cell C10, as shown in the below image.

Likewise, we can find the average of values with numeric condition as ‘1’.

Example #3 – AVERAGEIF Function With Dates

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

Now, let us learn how to use the AVERAGEIF function to find the average with date as condition.

The steps are:

Step 1: To begin with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:C10. Next, select the cell where we want to find the result. In this example, we need to select the cell C10.

Step 2: Next, insert the AVAERAGEIF function in Google sheets and select the cell range.

So, the complete formula is =AVERAGEIF(B2:B9,”1/6/2020″,C2:C9)

Step 3: Press Enter key.

We will be able to see the result in cell C10, as shown in the below image.

Likewise, we can find the average of values with date condition as ‘1/6/2020’ in Google sheets.

Example #4 – AVERAGEIF Function With Comparison Operators

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

Now, let us learn how to use the AVERAGEIF function to find the average with comparison operators as condition.

The steps are:

Step 1: To begin with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:C10. Next, select the cell where we want to find the result. In this example, we need to select the cell C10.

Step 2: Next, insert the AVAERAGEIF function and select the cell range.

So, the complete formula is =AVERAGEIF(B2:B9,”>1″,C2:C9)

Step 3: Press Enter key.

We will be able to see the result in cell C10, as shown in the below image.

Likewise, we can find the average of values with comparison operators as condition as ‘>1’ in Google sheets.

Important Things To Note

1. AVERAGEIF function in Google sheets is a function used to find the average of values with criteria.
2. Using AVERAGEIF function, we can use the following comparison operators.
   • Greater than (>)Lesser than (<)Greater than or Equal to (>=)Lesser than or Equal to (<=)Equal to (=)
   • Not Equal to (<>)

Frequently Asked Questions (FAQs)

Download Template

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

Recommended Articles

Guide to What Is Google Sheets AVERAGEIF Function. Here we learn how to use Google Sheets AVERAGEIF Function with examples and points to remember. You can learn more from the following articles. –

Barcode In Google Sheets

Add Time In Google Sheets

Bullet Points In Google Sheets