Excel Study · Module 4: Counting & summing with conditions
Class 33SUMIFS: many conditions
Intermediate1:41 videoFree
SUMIFS adds up the rows where every condition is true: how much did Ravi sell in March? It starts with what to add, then takes pairs, a range and its condition, one pair per condition.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2:A9 has salespeople's names, B2:B9 months (Mar or Apr) and C2:C9 sales amounts. Write a formula for F5 that adds up Ravi's sales in Apr.
The answer that works
✓ checked in Excel=SUMIFS(C2:C9, A2:A9, "Ravi", B2:B9, "Apr")
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.