=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...]) SUMIFS adds values from sum_range where all criteria conditions are satisfied. Always place the sum_range as the very FIRST argument.
SUMIFS Function in Excel & Google Sheets
The SUMIFS function adds numbers from a range that meet one or more criteria across dates, categories, and numeric thresholds.
1. Multiple Criteria (Region + Product)
To calculate total Revenue (D2:D100) for the “Midwest” Region (B2:B100) and “Software” Category (C2:C100):
=SUMIFS(D2:D100, B2:B100, "Midwest", C2:C100, "Software")2. Summing Between Two Dates (Monthly Revenue)
To sum sales occurring in Q1 2026 (Jan 1, 2026 to Mar 31, 2026):
=SUMIFS(D2:D100, A2:A100, ">=2026-01-01", A2:A100, "<=2026-03-31")(Or referencing date cells: =SUMIFS(D2:D100, A2:A100, ">=" & F1, A2:A100, "<=" & F2))
3. Wildcard Criteria (* and ?)
To sum sales for all customers whose names start with “Acme”:
=SUMIFS(D2:D100, B2:B100, "Acme*")Frequently Asked Questions
How do I sum sales between two dates using SUMIFS?
Use two criteria on the date column: =SUMIFS(Sales, Dates, ">=" & StartDate, Dates, "<=" & EndDate).
What is the syntax difference between SUMIF and SUMIFS?
In SUMIF (single condition), sum_range is the LAST argument. In SUMIFS (multiple conditions), sum_range is the FIRST argument.