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