SUMIFS
What it's for
SUMIFS adds up numbers, but only the ones that meet conditions you set — as many conditions as you need, all at once. Think of it as a filtered total: instead of adding an entire column, it only adds the rows that match everything you've asked for.
When you'd use it
Anytime you want a total that depends on more than one thing being true. A regular total of all sales columns doesn't tell you "how much did we sell of this specific product, in this specific month, above a certain price" — SUMIFS does.
How it works
SUMIFS always starts with the range you actually want added up. Everything after that comes in pairs: a range to check, and the condition that range needs to match. You can have just one pair, or many — SUMIFS only adds a row to the total if every single condition is true for that row at once.
A worked example
=SUMIFS(C:C, A:A, "Lace Set", B:B, ">10")Product names are in column A, quantity in column B, revenue in column C. Read as: add up column C, but only for rows where column A says 'Lace Set' AND column B is greater than 10.
A tip worth knowing
Every condition has to be true on the same row for that row to count. SUMIFS doesn't check "is there a Lace Set order somewhere, and separately, is there an order over 10 units somewhere else" — both conditions need to line up on one row.
Have a formula of your own you're stuck on?
Paste it and get an explanation →