Google Sheets function
SUMIFS function in Google Sheets
SUMIFS in Google Sheets adds values when corresponding cells meet multiple criteria. Each criterion has its own range, and every criteria range must match the size of the sum range. Use SUMIFS to total amounts for combinations such as one region and one payment status.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])Arguments
| Argument | Required | What it means |
|---|---|---|
sum_range | Yes | The range containing the values to add. |
criteria_range1 | Yes | The first range tested against a criterion. |
criterion1 | Yes | The pattern or test applied to criteria_range1. |
criteria_range2, criterion2, ... | No | Additional range and criterion pairs. |
Examples
Total paid sales in one region
| A | B | C | |
|---|---|---|---|
| 1 | Region | Status | Amount |
| 2 | East | Paid | 100 |
| 3 | West | Paid | 80 |
| 4 | East | Open | 40 |
| 5 | East | Paid | 60 |
=SUMIFS(C2:C5,A2:A5,"East",B2:B5,"Paid")Result: 160
SUMIFS adds the two amounts whose region is East and whose status is Paid.
Common mistakes
Using criteria ranges that do not match the sum range dimensions.
Give every criteria range the same number of rows and columns as the sum range.
Putting the sum range after the criteria pairs.
Place the range to add first, followed by each criteria range and criterion.