Excel + Google Sheets · SUMIFS
Add up only what matches your rules
Sums a column, but only the rows that meet every condition you set.
The formula
=SUMIFS(C2:C5, A2:A5, "North", B2:B5, "Paid")What each part means
C2:C5What to add upA2:A5, "North"1st conditionB2:B5, "Paid"2nd condition (add as many as you want)
Example
| A | B | C | |
|---|---|---|---|
| 1 | Region | Status | Amount |
| 2 | North | Paid | 1,200 |
| 3 | South | Paid | 900 |
| 4 | North | Pending | 700 |
| 5 | North | Paid | 450 |
| 6 | North + Paid |
| A | B | C | |
|---|---|---|---|
| 1 | Region | Status | Amount |
| 2 | North | Paid | 1,200 |
| 3 | South | Paid | 900 |
| 4 | North | Pending | 700 |
| 5 | North | Paid | 450 |
| 6 | North + Paid | 1,650 |
Step by step
- Click cell C6.
- Type the formula:
=SUMIFS(C2:C5, A2:A5, "North", B2:B5, "Paid") - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English SUMIFS
- Español SUMAR.SI.CONJUNTO
- Português SOMASES