Formula example
SUMIFS with Multiple Criteria
You want to total sales where Region is East and Product is Widget.
Copyable formula
=SUMIFS(D2:D100, B2:B100, "East", C2:C100, "Widget")Sample data
| Date | Region | Product | Amount |
|---|---|---|---|
| 2026-01-04 | East | Widget | 420 |
| 2026-01-12 | West | Widget | 310 |
| 2026-02-03 | East | Gadget | 275 |
| 2026-02-15 | East | Widget | 640 |
Formula explanation
- D2:D100 is the range being summed.
- B2:B100 must equal East.
- C2:C100 must equal Widget on the same row.
Common errors
- Criteria ranges must match the sum range shape.
- Text criteria require quotes.
- SUMIFS uses AND logic across criteria pairs.
Build your own version
Use the deterministic builder for this pattern: SUMIFS Formula Builder.
Related formulas
FAQ
Can SUMIFS use OR logic?
Not directly in one criteria pair. Use multiple SUMIFS formulas or array logic for OR cases.
Does criteria order matter?
No, but keeping ranges near the source column order makes formulas easier to audit.