Statistical
Modern
COUNTIFS
Counts the cells that meet multiple conditions.
Available in All versions (Excel 2007+)
Syntax
COUNTIFS(criteria_range1, criteria1, ...)What it returns
The number of cells matching all criteria.
Arguments
| Argument | Required | Description |
|---|---|---|
criteria_range1 |
Yes | The first range to test. |
criteria1 |
Yes | The condition applied to criteria_range1. |
… |
No | Add criteria_range/criteria pairs as needed (up to 127). |
Example
Criteria
City = "Paris" AND Amount > 100
| A | B | |
|---|---|---|
| 1 | City | Amount |
| 2 | Paris | 120 |
| 3 | Lyon | 200 |
| 4 | Paris | 200 |
| 5 | Paris | 90 |
Count
2
Count rows meeting every criterion: Paris and over 100 (2).
=COUNTIFS(A2:A100, "Paris", B2:B100, ">100")Important to know
All ranges must be the same size.
Conditions are combined with AND (all must match).