SUMIFS Function in Google Sheets
Sums values that meet multiple conditions. The multi-criteria version of SUMIF, and the cleanest way to get filtered totals from a flat table.
Syntax
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])Returns: The total of sum_range for rows where ALL criteria are met.
Excel equivalent: SUMIFS (identical)
Parameters
| Name | Required | Description |
|---|---|---|
| sum_range | Required | The range to sum. |
| criteria_range1 | Required | The first range to test. |
| criterion1 | Required | The first condition. |
| criteria_range2, criterion2, ... | Optional | Additional range/criterion pairs. All conditions must be TRUE for a row to be included. |
Examples
Sales for one product in one region
=SUMIFS(D:D, A:A, "Apple", B:B, "West")Sums column D where column A is "Apple" AND column B is "West". Both conditions must match.
Q1 revenue for a customer
=SUMIFS(C:C, A:A, "Acme Corp", B:B, ">="&DATE(2026,1,1), B:B, "<"&DATE(2026,4,1))Sums revenue for Acme Corp between Jan 1 and Mar 31 2026. Note the same criteria_range (B:B) used twice with different bounds for a date window.
Excluded match using "<>"
=SUMIFS(D:D, A:A, "<>Tax", B:B, "Paid")Sums amounts where the category is NOT "Tax" AND the status is "Paid". <> is the not-equal operator.
When to use an alternative
- QUERY — You want grouped totals across many category combinations at once.
- FILTER + SUM — Your criteria are dynamic arrays (entire calculated condition columns).
- Pivot Table — You're exploring data and want interactive slicing without writing formulas.
Common errors and how to fix them
#VALUE!
Cause: sum_range and criteria_range have different dimensions.
Fix: All ranges must be the same size. SUMIFS aligns row-by-row.
Returns 0
Cause: One criterion is too restrictive — usually a hidden whitespace or type mismatch.
Fix: Test each criterion individually with COUNTIFS to find which one is filtering everything out.
Related functions
Frequently Asked Questions
Is the order of arguments different from SUMIF?
Yes, intentionally — SUMIFS puts sum_range FIRST, then range/criterion pairs. SUMIF puts sum_range LAST. This trips up everyone the first time. Mnemonic: SUMIFS leads with what to sum so you can see it without scrolling through criteria.
Can SUMIFS use OR logic across criteria?
No — all criteria are AND. For OR, either: (1) sum two SUMIFS results together for each OR branch, or (2) use SUMPRODUCT with explicit boolean math, or (3) use QUERY with a WHERE clause.