# How to Use Excel AVERAGEIFS Function (Examples + Video)

## Excel AVERAGEIFS Function (Example + Video) ### When to use Excel AVERAGEIFS Function

Excel AVERAGEIFS function can be used when you want to get the average (arithmetic mean) of all the cells in a range that meets multiple criteria.

### What it Returns

It returns a number that represents the average (arithmetic mean) of the arguments.

### Syntax

=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …).

### Input Arguments

• average_range – the range of cells you want to average.
• criteria_range1, criteria_range2,.. – the ranges against which the criteria are evaluated. There can be up to 127 ranges and associated criteria.
• criteria1, criteria2,.. – the criteria that is applied to its associated range. For example, criteria1 is applied to criteria_range1, criteria2 is applied to criteria_range2, and so on..

• If there are blanks or text in average_range, it returns a #DIV/0! error.
• Criteria could be a number, expression, cell reference, text, or a formula.
• Criteria which are text or mathematical/logical symbols (such as =,+,-,/,*) should be in double quotes.
• Wildcard characters can be used in criteria.
• Cells in average_range are averaged only when all the conditions are met.
• Range size of average_range and all the criteria_range must be equal.

## Excel AVERAGEIFS Function – Video Tutorial

Related Excel Functions:

Other Excel tutorials you may find useful: FREE EXCEL BOOK