← Back to level 2
Level 2Next
COUNTIFS
A medium counting formula for multiple conditions, useful when a row should count only if several rules are true.
Syntax
=COUNTIFS(...)Step-by-step explanation
- 1Choose the range that will be checked against your condition.
- 2Add the criteria so Excel knows which rows should count or sum.
- 3Review the result to make sure only matching rows were included.
Common mistakes
Using ranges of different sizes
Putting criteria in the wrong order
Forgetting that every condition must be satisfied
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=COUNTIFS(A1:B2)
Result
68
Worked example
- 1Scan the status values in the table and count the ones that match the rule.
- 2Enter =COUNTIFS(A1:B2) to count only the matching cells.
- 3The example count should be 68.
Practice area
Use COUNTIFS when you need a count that depends on two or more filters at the same time.
Match against the syntax block above.
Real-life use cases
Filtered reportsMulti-rule attendance checksCompliance counts
Related formulas