SUMIFS Generator - Sum with Multiple Criteria | Excel & Sheets
Adds all cells that meet multiple criteria. More powerful than SUMIF for complex conditions.
Master SUMIFS: Sum with Multiple Conditions
The SUMIFS function is an enhanced version of SUMIF that allows you to apply multiple criteria. It's essential for financial analysis, sales reports, and data aggregation.
SUMIFS vs SUMIF
| Feature | SUMIF | SUMIFS |
|---|---|---|
| Criteria | Single | Multiple |
| Syntax Order | Range, Criteria, Sum Range | Sum Range first, then Criteria pairs |
Common Use Cases
- Sum sales by region AND product category
- Calculate total expenses by date range AND department
- Aggregate data with multiple filters
Common Errors & Fixes
SUMIFS returns 0 or wrong total
Causes:- Sum range and criteria ranges have different heights or columns.
- Criteria in wrong order (text without quotes, date not as DATE() or cell ref).
- Using SUMIF-style argument order (sum range must come first in SUMIFS).
Fixes:- Use same-sized ranges: e.g. A1:A100, B1:B100, C1:C100.
- Put text in quotes; use ">="&A1 for dates where A1 is a date.
- Syntax: =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2).
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More