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, ...])

• average_range: The range of cells containing the numbers you want to average.
• criteria_range1: The range of cells to apply the first criterion to.
• criterion1: The condition that must be met for a number to be included in the average. This can be a number, a cell reference, or a text string.
• [criteria_range2, criterion2, ...]: (Optional) Additional pairs of criteria ranges and criteria to apply.

Example

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

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")

3. 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.