AVERAGEIFS is an Excel function that calculates the average of a range of numbers based on one or more criteria. It helps you find the average of values that meet specific conditions.


AVERAGEIFS(range, criteria_range1, criteria1, [criteria_range2], [criteria2], …)


rangeThe range of numbers you want to calculate the average for.
criteria_range1The first range of cells that contains the criteria for averaging.
criteria1The first criteria that defines which values to include in the average.
[criteria_range2](Optional) The second range of cells for additional criteria.
[criteria2](Optional) The second criteria for further refining the average calculation.
Additional pairs of criteria_range and criteria can be added as needed.

How to use

You can use the AVERAGEIFS function to find the average of a range of values that meet specific conditions. Here’s how to use it with multiple examples:

Example 1: Calculate the average of scores for students who scored above 80 in the “Math” subject.

Example 2: Calculate the average of sales for products in the “Electronics” category with a price greater than $500.

Example 3: Calculate the average age of employees in the “Sales” department who have been with the company for more than 5 years.

Example 4: Calculate the average of temperatures in a specific date range.

Example 5: Calculate the average of values based on multiple criteria.

These are just a few examples of how you can use AVERAGEIFS to calculate averages based on specific conditions. You can include multiple criteria pairs to further refine your calculations.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.