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