Combining functions
Open the practice in the trainer →
Harder questions about a table are answered by combining functions:
- who is best —
INDEX(names, MATCH(MAX(scores), scores, 0));
- maximum among values meeting a condition —
MAXIFS, MINIFS;
- count by several conditions —
COUNTIFS;
- average by condition —
AVERAGEIF.
Tasks in the trainer
- In F2:F9 calculate each student’s total score.
- In I2 return the surname of the student with the highest total (the first one if there is a tie).
- In I3 — the highest total among the 9B students.
- In I4 — how many students got 5 in all three subjects.
- In I5 — the average total of the 9A students.
Solve the tasks in the trainer →