17.9 C
London
Thursday, July 24, 2025
HomeSoftware TutorialsGoogle SheetsHow to Use AVERAGEIFS in Google Sheets (3 Examples)

How to Use AVERAGEIFS in Google Sheets (3 Examples)

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

The AVERAGEIFS function in Google Sheets can be used to find the average value in a range if the corresponding values in another range meet certain criteria.

This function uses the following basic syntax:

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

where:

  • average_range: The range to calculate average from
  • criteria_range1: The first range to check for certain criteria
  • criterion1: The criteria to analyze in the first range

The following examples show how to use this function in different scenarios with the following dataset in Google Sheets:

Example 1: AVERAGEIFS with One Character Column

We can use the following formula to calculate the average value in the Points column where the Team column is equal to “Mavs”:

=AVERAGEIFS(C2:C11, A2:A11, "Mavs")

The following screenshot shows how to use this formula in practice:

The average value in the Points column where the Team column is equal to “Mavs” is 24.6.

We can manually verify this is correct by calculating the average points for the Mavs players:

Average: (22 + 28 + 25 + 30 + 18) / 5 = 24.6.

Example 2: AVERAGEIFS with Two Character Columns

We can use the following formula to calculate the average value in the Points column where the Team column is equal to “Mavs” and the Position column is equal to “Guard”:

=AVERAGEIFS(C2:C11, A2:A11, "Mavs", B2:B11, "Guard")

The following screenshot shows how to use this formula in practice:

AVERAGEIFS in Google Sheets

The average value in the Points column where the Team column is equal to “Mavs” and the Position column is equal to “Guard” is 29.

We can manually verify this is correct by calculating the average points for the Mavs players who are Guards:

Average: (22 + 28) / 2 = 25.

Example 3: AVERAGEIFS with Character & Numeric Columns

We can use the following formula to calculate the average value in the Points column where the Team column is equal to “Spurs” and the Points column is greater than 15:

=AVERAGEIFS(C2:C11, A2:A11, "Spurs", C2:C11, ">15")

The following screenshot shows how to use this formula in practice:

The average value in the Points column where the Team column is equal to “Spurs” and the Points column is greater than 15 is 23.67.

We can manually verify this is correct by calculating the average points for the Spurs players who scored more than 15 points:

Average: (19 + 22 + 30) / 3 = 23.67.

Note: You can find the complete online documentation for the AVERAGEIFS function here.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: How to Calculate Mean, Median & Mode
Google Sheets: How to Calculate Average If Not Blank
Google Sheets: How to Calculate Exponential Moving Average

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories