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:
How to Calculate Average Annual Growth Rate (AAGR) in Excel
