Count rows that meet a condition
Count how many rows carry a given label, ignoring everything else.
The formula
=COUNTIF(A:A, "Paris")How it works
Criteria
City = "Paris"
| A | B | |
|---|---|---|
| 1 | City | Amount |
| 2 | Paris | 120 |
| 3 | Lyon | 80 |
| 4 | Paris | 200 |
| 5 | Nice | 150 |
Count
2
Count how many rows have City = Paris (2).