AVERAGEIFS Function In Excel

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:

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