The AVERAGEIFS function in Excel is similar to AVERAGEIF but allows you to find the average of a range of cells that meet multiple criteria. The function syntax is as follows:
Syntax
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
• average_range: the range of cells to calculate the average for.
• criteria_range1: the first range of cells to evaluate against the first criteria.
• criteria1: the first condition or criteria that must be met.
• [criteria_range2, criteria2]: (optional) additional ranges of cells and conditions to evaluate.
You can specify up to 127 range/criteria pairs in the formula.