COUNTA answers "how many cells have anything in them?" Unlike COUNT, it counts text, logical values and error values as well as numbers; only truly empty cells are excluded. That makes it the right tool for counting rows, entries or responses, and the wrong tool for counting numbers — a distinction that explains most COUNTA surprises.
Returns a number. Counts non-empty cells of any type; blanks are excluded.
Three different questions about the same range. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =COUNTA(A2:A8) | 6 | Five numbers plus the text cell |
| =COUNTA(C2:C8) | 7 | Every label is non-empty |
| =COUNTA(A2:A8,"x") | 7 | Range plus a literal |
| =COUNTA(A2:A8,C2:C8) | 13 | Two ranges combined |
| =COUNT(A2:A8) | 5 | COUNT sees only the numbers |
| =COUNTBLANK(A2:A8) | 1 | The one empty cell |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to compare COUNTA, COUNT and COUNTBLANK.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
COUNTA is a core statistical function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
COUNTA is one piece. The full course walks the toolkit end to end with live, measured examples.