Formula guide · Excel and Google Sheets · Updated May 13, 2026
SUMIFS with Multiple Criteria
Use SUMIFS to add numbers only when rows match two or more conditions.
Quick Answer
SUMIFS adds values in sum_range only when every criteria range passes its matching condition.
Copyable Formula
=SUMIFS(D2:D20,B2:B20,"West",C2:C20,"Paid")Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)Excel and Google Sheets
Worked Example
| B | C | D |
|---|---|---|
| Region | Status | Amount |
| West | Paid | $120 |
| West | Open | $90 |
| East | Paid | $75 |
Result: Sums Amount only for rows where Region is West and Status is Paid.
Steps
- Select the numeric range first.
- Add each criteria range and criteria pair after it.
- Make sure each criteria range has the same size as the sum range.
Common Mistakes
- Putting the criteria range before the sum range, which is the SUMIF order, not SUMIFS.
- Using mismatched ranges with different row counts.
- Forgetting quotes around text criteria.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.