Both count cells, but they count different things. COUNT counts only cells holding numbers (dates and zero included); COUNTA counts every cell that is not empty — text, logical values, errors and even empty strings. The single letter "A" means "all". Below, the same mixed range is counted by both, live.
COUNT answers 'how many numbers?' (3 on the mixed range); COUNTA answers 'how many filled cells?' (6). Use COUNT for an average denominator, COUNTA for completion and non-blank checks.
What each function counts on the same mixed range.
| Capability | COUNT | COUNTA | Why it matters |
|---|---|---|---|
| Counts numbers | ✓ Numeric cells | ✓ Numeric cells | Both count 10, 0, 30. |
| Counts text | ✗ Ignored | ✓ Counted | The core difference: 'hello' adds 1 to COUNTA only. |
| Counts logical TRUE/FALSE | ✗ Ignored | ✓ Counted | TRUE adds 1 to COUNTA, 0 to COUNT. |
| Counts empty string "" | ✗ Not a number | ✓ Non-empty | A formula "" counts in COUNTA (measured 1). |
| Counts a zero | ✓ Zero is a number | ✓ Non-empty | Neither skips 0. |
| Skips truly blank cells | ✓ Blank skipped | ✓ Blank skipped | Only a genuinely empty cell is skipped by both. |
| Average-denominator safe | ✓ Matches AVERAGE | ✗ Inflates denominator | SUM/COUNTA understates the mean when text is present. |
Same argument shape; the difference is the counting test.
One editable mixed column, two counters. Pick a scenario or type your own — both re-evaluate live so you see exactly which cells each counts.
These are not feature-list claims. Each pair below was evaluated on the identical dataset in the HyperFormula 3.5 engine, and the outputs are baked from that run. Reproduce them in the playground above.
=COUNT(B2:B7)=COUNTA(B2:B7)=COUNT(B2,B6)=COUNTA(B2,B6)=COUNT(B3)=COUNTA(B3)=COUNT(B7)=COUNTA(B7)=COUNT(B5)=COUNTA(B5)=COUNT(B4)=COUNTA(B4)=COUNT(B2)=COUNTA(B2)Engine cost on a mixed numeric/text column (relative only, not Microsoft Excel).
| Table size | COUNT | COUNTA |
|---|---|---|
| 1,000 rows × 200 lookups | 81.66 ms | 68.5 ms |
| 5,000 rows × 200 lookups | 593.88 ms | 570.62 ms |
| 10,000 rows × 200 lookups | 1986.03 ms | 1953.48 ms |
Pick by the question you are asking.
| Situation | Use | Why |
|---|---|---|
| Count numeric sales amounts | COUNT | Text headers and labels are ignored. |
| Count completed rows (any value) | COUNTA | A row with text or a flag still counts as filled. |
| Count cells containing zero | Either | Zero is a number: both count it. |
| Count non-blank text IDs | COUNTA | COUNT returns 0 on text; COUNTA counts each ID. |
| Count TRUE/FALSE flags | COUNTA | COUNT ignores logical values; COUNTA counts them. |
| Denominator for a manual average | COUNT | Matches AVERAGE, which uses only the numbers. |
Common counting tasks, side by side.
| Task | COUNT / old way | COUNTA | What changed |
|---|---|---|---|
| Average denominator | =SUM(B2:B7)/COUNT(B2:B7) | =SUM(B2:B7)/COUNTA(B2:B7) | COUNTA version understates the mean when text is present. |
| Completion rate | =COUNT(B2:B7)/ROWS(B2:B7) | =COUNTA(B2:B7)/ROWS(B2:B7) | COUNTA counts any filled row as done. |
| Non-blank ID audit | =COUNT(IDs) | =COUNTA(IDs) | A gap means some IDs are stored as text. |
| Count blanks | =COUNTBLANK(B2:B7) | =ROWS(B2:B7)-COUNTA(B2:B7) | COUNTA treats "" as non-empty; COUNTBLANK does not. |