# AVERAGEIFS function

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.

## Syntax

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

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