← Back to level 2
Level 2Next
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
Worked example
- 1Scan the status values in the table and count the ones that match the rule.
- 2Enter =COUNTIF(A1:A2,"Paid") to count only the matching cells.
- 3The example count should be 1.
Practice area
Count how many orders are paid.
Match against the syntax block above.