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 Product Name in column B. You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | AProduct ID | BProduct Name | CCategory | DSales |
|---|---|---|---|---|
| 2 | P001 | Apple | Food | 1200 |
| 3 | P002 | Banana | Food | 980 |
| 4 | P003 | Notebook | Stationery | 450 |
| 5 | P004 | Pen | Stationery | 300 |
| 6 | P005 | Grapes | Food | 1500 |
| 7 | P006 | Ruler | Stationery | 250 |
| 8 | P007 | Peach | Food | 860 |
How to Use (Formula)
=COUNTA(B2:B8)Result
7
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.