← Back to level 1
Level 1Next
COUNT
A easy counting formula for numeric cells only, useful when blanks and text should not be part of the result.
Syntax
=COUNT(...)Step-by-step explanation
- 1Choose the range of cells that contains numeric values you want to count.
- 2Enter COUNT in an empty cell and point it to the number range.
- 3Press Enter to confirm that text and blank cells were ignored.
Common mistakes
Expecting text cells to be counted
Choosing the wrong range
Using COUNTA when only numbers should count
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=COUNT(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =COUNT(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use COUNT when you need to count how many rows contain numbers such as scores or invoice amounts.
Match against the syntax block above.