AVERAGEIFS Function
Purpose
Calculates the arithmetic mean of all cells in a range that meet multiple criteria.
Syntax
EXCEL
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)