Excel Study · Module 4: Counting & summing with conditions
Class 34AVERAGEIF & AVERAGEIFS
Intermediate2:03 videoFree
AVERAGEIF averages only the rows that match one condition: the average score of class 7A. It works like SUMIF, with what to average last.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2:A9 has class names (7A or 7B) and C2:C9 has test scores. Write a formula for F7 that gives the average score of class 7B.
The answer that works
✓ checked in Excel=AVERAGEIF(A2:A9,"7B",C2:C9)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.