Excel Study · Module 4: Counting & summing with conditions
Class 32SUMIF
Intermediate1:34 videoFree
SUMIF adds up only the rows that match a condition: how much did Priya sell, when her orders are spread across the list? Give it where to look, what to find, and what to add, in that order: the sum range comes last.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2:A9 has salespeople's names and B2:B9 the amount of each sale. Write a formula for E4 that adds up all of Omar's sales.
The answer that works
✓ checked in Excel=SUMIF(A2:A9,"Omar",B2:B9)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.