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.


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

Additional Notes

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 – Live Example

Excel AVERAGEIFS Function – Video Tutorial

Related Excel Functions:

Excel AVERAGE Function. Excel AVERAGEIF Function. Excel SUM Function. Excel SUMIF Function. Excel SUMIFS Function. Excel SUMPRODUCT Function.

Other Excel tutorials you may find useful:

How to Calculate Average Annual Growth Rate (AAGR) in Excel