← Back to level 2
Level 2Level 2
COUNTIF
Counts cells that satisfy a condition.
Syntax
=COUNTIF(range, criteria)Step-by-step explanation
- 1Point to the cells you want to test.
- 2Use criteria to count matching values or ranges.
- 3A staple for attendance, status, and quality checks.
Common mistakes
Counting the wrong column
Using wildcards without understanding them
Mixing text and numeric criteria
Example table
A quick scenario to connect the syntax to the result.
| Paid |
| Pending |
Formula
=COUNTIF(A1:A2,"Paid")
Result
1
Practice area
Count how many orders are paid.
Match against the syntax block above.