How to Use SUMIFS in Excel
Last updated: 2026-09-06
⚡ Quick Answer
SUMIFS expands standard summation by letting you apply multiple criteria ranges simultaneously.
=SUMIFS(D2:D100, A2:A100, "North", B2:B100, ">1000")📊 Visual Demo
HOME · INSERT · FORMULAS · DATA
fx =SUMIFS(D2:D100, A2:A100, "North", B2:B100, ">1000")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 1 | North | 1200 | $15,000 | =SUMIFS(D:D, A:A, "North", C:C, ">1000") |
| 2 | 2 | South | 800 | $9,000 | - |
| 3 | 3 | North | 1500 | $22,000 | Total: $37,000 |
🧠 Deep Dive
SUMIFS expands standard summation by letting you apply multiple criteria ranges simultaneously.
Key Insights
- SUMIF/COUNTIF take one criteria; SUMIFS take many.
- Expanding ranges create running totals.
Common Mistakes
- Mismatched range sizes in SUMIFS.
- Quoting numeric criteria cell references.
Pro Tips
- Make criteria ranges full columns.
- Test COUNTIFS first.
FAQ
What does this formula do in plain English?
SUMIFS expands standard summation by letting you apply multiple criteria ranges simultaneously.
Why is my formula not working?
Mismatched range sizes in SUMIFS.
Does this work in Google Sheets?
Yes, this syntax is fully compatible with Google Sheets.
What is the most common mistake?
Quoting numeric criteria cell references.
Related Guides
How to Use COUNTIFS in ExcelHow to Calculate Cumulative SumHow to Calculate Moving AverageHow to Use SUMIF in ExcelExcel Error Hub
Need Complete Playbooks?
Download our verified manuals covering ERP Cleanup and Modeling.
Explore Playbook Series (From ₹199)