SUMIFS with multiple criteria
Add up values that meet several conditions at once, like sales for one region and status.
The formula
Excel and Google Sheets
=SUMIFS(D2:D100, B2:B100, "West", C2:C100, "Paid")How it works
D2:D100The numbers to add up.
B2:B100, "West"First condition: the region must be West.
C2:C100, "Paid"Second condition: the status must be Paid.
Example
| B: Region | C: Status | D: Amount |
|---|---|---|
| West | Paid | 200 |
| West | Open | 150 |
| East | Paid | 300 |
| West | Paid | 50 |
Tips
- Result for this data: 250.
- Replace "West" with a cell reference like G2 to make the criteria easy to change.
- Use "<>" to mean "not empty" and "" to mean "empty".