Google Sheets function
SUMIF function in Google Sheets
SUMIF in Google Sheets adds values when cells in a range match one criterion. It can sum the tested range itself or a separate sum range. Use SUMIF to total amounts for one status, category, threshold, person, or other single condition.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=SUMIF(range, criterion, [sum_range])Arguments
| Argument | Required | What it means |
|---|---|---|
range | Yes | The range tested against the criterion. |
criterion | Yes | The pattern or test applied to the range. |
sum_range | No | The range to add when it differs from the tested range. |
Examples
Total paid invoices
| A | B | C | |
|---|---|---|---|
| 1 | Invoice | Status | Amount |
| 2 | A-1 | Paid | 120 |
| 3 | A-2 | Open | 80 |
| 4 | A-3 | Paid | 150 |
=SUMIF(B2:B4,"Paid",C2:C4)Result: 270
SUMIF adds the amounts whose status cell contains Paid.
Common mistakes
Using tested and summed ranges with different shapes.
Keep the criterion range and sum range aligned row for row.
Trying to apply several criteria with SUMIF.
SUMIF handles one criterion. Choose a multi-criteria function when more tests are required.