Average Chinese score of Class Two = average (if (A2: A 100 = 2, C2: C 100)) array formula, ending with ctrl+shift+enter.
Class average math score 1 = average (if (A2: A 100 = 1, E2: E 100)) array formula, ending with ctrl+shift+enter.
Average math score of class 2 = average (if (A2: A 100 = 2, E2: E 100)) array formula, and ctrl+shift+enter ends.
Class average total score 1 = average (if (A2: A 100 = 1, G2: G 100)) array formula, ending with ctrl+shift+enter.
Average total score of class 2 = average (if (A2: A 100 = 2, G2: G 100)) array formula, ending with ctrl+shift+enter.
The average Chinese scores of the top seven students in the class 1 = average (if (and (A2: A 100 = 1, H2: H 100)
Average math scores of the top 7 students in the class 1 = average (if (and (A2: A 100 = 1, H2: H 100)
The average total score of the top 7 students in the class 1 = average (if (and (A2: A 100 = 1, H2: H 100)
2: 100 depends on how much data in the table needs to be modified. If 1 and 2 in the class column are in text format, change 1 and 2 in the formula to 1 and 2.