SUMIFS in Google Sheets
Use SUMIFS to add numbers that meet several conditions at once — sales in the West region that are also marked Paid, orders in a date range over a certain amount.
=SUMIFS(C2:C100, A2:A100, "West", B2:B100, "Paid")
Adds C2:C100 only where A equals West AND B equals Paid. The sum range comes first, then range/criterion pairs.
How it works
SUMIFS starts with the sum range, then takes range/criterion pairs. A row is added only if it satisfies every pair (an AND). All ranges must be the same size. Use operators with & and a cell to build dynamic thresholds, e.g. ">="&E1.
Variations
Total inside a date range
=SUMIFS(C2:C100, D2:D100, ">="&E1, D2:D100, "<="&E2)
E1 and E2 hold the start and end dates.
Two text conditions
=SUMIFS(C:C, A:A, "West", B:B, "Retail")
Both labels must match on the same row.
Match a value from another cell
=SUMIFS(C:C, A:A, E1, B:B, ">"&E2)
E1 supplies the text; E2 supplies the number threshold.
Examples
| Scenario | Formula |
|---|---|
| Paid orders over $500 | =SUMIFS(C:C, B:B, "Paid", C:C, ">500") |
| One region, one month | =SUMIFS(C:C, A:A, "East", D:D, ">="&DATE(2026,3,1), D:D, "<"&DATE(2026,4,1)) |
| Everything except one status | =SUMIFS(C:C, B:B, "<>Cancelled") |
FAQ
Why is SUMIFS returning 0?
Usually the ranges are different sizes, or the criteria don't match exactly (extra spaces, wrong data type). Make every range the same height and check for stray spaces.
Does SUMIFS put the sum range first or last?
First. SUMIFS(sum_range, criteria_range1, criterion1, ...) — the opposite order from SUMIF.
How do I use SUMIFS with a date range?
Add two conditions on the date column: one for >= start and one for <= end, joining the operator to the cell with &.