Stat · Nov 16, 2026

The COUNTA function,
measured & explained.

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.

D1
fx
=COUNTA(…)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How COUNTA works

Returns a number. Counts non-empty cells of any type; blanks are excluded.

=COUNTA(value1, value2, ...)
value1The first item, reference or range to count non-empty cells in.
value2, ...Optional additional items or ranges (up to 255).
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — What counts as non-empty

COUNTA vs COUNT vs COUNTBLANK

Three different questions about the same range. Click any row to load it.

Counting entries, numbers and gaps

ExpressionResultWhy
=COUNTA(A2:A8)6Five numbers plus the text cell
=COUNTA(C2:C8)7Every label is non-empty
=COUNTA(A2:A8,"x")7Range plus a literal
=COUNTA(A2:A8,C2:C8)13Two ranges combined
=COUNT(A2:A8)5COUNT sees only the numbers
=COUNTBLANK(A2:A8)1The one empty cell
⚠ COUNTA counts text, so COUNTA(A2:A8)=6 while COUNT(A2:A8)=5. If you want a numeric count, use COUNT; if you want gaps, use COUNTBLANK.
COUNTA = COUNT + (text/logical/error cells). COUNTA + COUNTBLANK = total cells in the range. A formula returning "" counts as blank; a space " " does not.
// 03 — Try it live

Interactive COUNTA playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to compare COUNTA, COUNT and COUNTBLANK.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

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.

// 05 — Cross-platform

Where COUNTA works

COUNTA is a core statistical function present in every Excel version and platform.

PlatformSupportNotesGotcha
✓ Supported full COUNTA◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master stat

COUNTA is one piece. The full course walks the toolkit end to end with live, measured examples.

  • Counts numbers, text, logical and errors
  • Blanks excluded; "" counts as blank
  • COUNTA+COUNTBLANK=total cells
  • Use COUNT for a numeric count
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked