Sum with several conditions
Keep only the rows that satisfy every condition at once, then add them up.
The formula
=SUMIFS(B:B, A:A, "Paris", B:B, ">100")How it works
Criteria
City = "Paris" AND Amount > 100
| A | B | |
|---|---|---|
| 1 | City | Amount |
| 2 | Paris | 120 |
| 3 | Lyon | 200 |
| 4 | Paris | 200 |
| 5 | Paris | 90 |
Total
320
Sum only rows meeting every criterion. Paris/90 is excluded.