How to Use AVERAGEIFS in Google Sheets

AVERAGEIFS is a function in Google Sheets that calculates the average of numbers that meet multiple criteria. It is an extension of the AVERAGEIF function, which only takes one criterion. AVERAGEIFS can be useful when you want to calculate the average of values that meet multiple conditions.

Here's how to use AVERAGEIFS in Google Sheets:

  1. Open your Google Sheet or create a new one.
  2. Click on the cell where you want to display the result of the AVERAGEIFS function.
  3. Type the following formula, replacing the placeholders with the appropriate values:
=AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])


Let's say you have a list of students with their scores in different subjects, as shown below:

Student Subject Score
Alice Math 90
Alice English 80
Bob Math 85
Bob English 95
Charlie Math 75
Charlie English 70

You want to calculate the average score for students who scored above 80 in Math and above 75 in English. Follow these steps:

  1. Click on an empty cell, for example, A8.
  2. Type the following formula:
=AVERAGEIFS(C2:C7, B2:B7, "Math", C2:C7, ">80", B2:B7, "English", C2:C7, ">75")
  1. Press Enter.

The result should be 87.5, which is the average of Alice's and Bob's scores in Math, as they meet both criteria.

Did you find this useful?