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 formula is suitable when you need to find the average of a range of cells that meet multiple specified criteria.

Example: If you have a list of test scores in cells A1 to A10, and you want to find the average score for students with a grade of A and age less than 18, you can use the formula =AVERAGEIFS(A1:A10, B1:B10, “A”, C1:C10, “<18"). If the scores are [75, 85, 90, 70, 80, 85, 80, 75, 90, 80], the grades are ["B", "A", "A", "C", "B", "A", "A", "B", "A", "B"], and the ages are [15, 16, 17, 18, 19, 17, 16, 18, 17, 18], the average score for students with a grade of A and age less than 18 is 85.