Sum values by category
Add up only the rows that match one label — here every amount recorded for Paris.
The formula
=SUMIF(A:A, "Paris", B:B)How it works
Criteria
City = "Paris"
| A | B | |
|---|---|---|
| 1 | City | Amount |
| 2 | Paris | 120 |
| 3 | Lyon | 80 |
| 4 | Paris | 200 |
| 5 | Nice | 150 |
Total
320
Add up Amount only for rows where City is Paris (120 + 200).