AVERAGEIFS
Definition: AVERAGEIFS is a function that returns the average of a range of cells that meet multiple specified criteria. Syntax: =AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ...) Situation: This...