AVERAGEIFS
Syntax
=AVERAGEIFS(average_range; criteria_range1; criteria1; [criteria_range2; criteria2]; ...)
Description
Calculates the average of cells that meet multiple criteria.