How do I use COUNTA in Excel?
Use COUNTA when you want to count non-empty cells. Enter Value 1, Value 2 in that order, then add optional arguments when needed.
Excel Function
COUNTA
Counts non-empty cells.
COUNTA(value1, [value2], ...)Arguments
value1
RequiredSpecify a reference range. You can drag or click start/end cells.
value2
OptionalSpecify a reference range. You can drag or click start/end cells.
Practice Preview
Use COUNTA to count non-empty cells in Value in column B.
Example Table
| # | AItem | BValue | CNotes |
|---|---|---|---|
| 2 | 1 | 120 | Number |
| 3 | 2 | 100 | Number stored as text |
| 4 | 3 | Blank | |
| 5 | 4 | 45 | Number |
| 6 | 5 | Done | Text |
| 7 | 6 | 0 | Number |
| 8 | 7 | Blank |
How to Use (Formula)
=COUNTA(B2:B8)Result
5
Practice This Function
COUNTA FAQ
Where can I practice COUNTA?
Use the "Start Function Practice" button to jump straight into COUNTA drills.
What arguments does COUNTA use?
The main arguments are Value 1, Value 2. Start with the required ones, then add optional arguments if needed.