← Back to level 1
Level 1Next
COUNTA
A easy counting formula for non-empty cells when you need to know how many entries were filled in.
Syntax
=COUNTA(...)Step-by-step explanation
- 1Choose the range of cells that may contain text, numbers, or other values.
- 2Enter COUNTA in an empty cell and point it to the full data range.
- 3Press Enter to confirm that every non-empty cell was counted.
Common mistakes
Confusing it with COUNT
Including hidden helper columns by mistake
Expecting blanks to be counted
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=COUNTA(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =COUNTA(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use COUNTA when submitted forms, records, or rows should all count as long as they are not blank.
Match against the syntax block above.