AVERAGEIF

Definition: AVERAGEIF is a function that returns the average of a range of cells that meet a specified criterion.

Syntax: =AVERAGEIF(range, criteria, [average_range])

Situation: This formula is suitable when you need to find the average of a range of cells that meet a specified criterion.

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, you can use the formula =AVERAGEIF(B1:B10, “A”, A1:A10). If the scores are [75, 85, 90, 70, 80, 85, 80, 75, 90, 80], and the grades are [“B”, “A”, “A”, “C”, “B”, “A”, “A”, “B”, “A”, “B”], the average score for students with a grade of A is 85.