COUNT vs COUNTA vs COUNTBLANK: Which to Use

Excel & Google Sheets

How it works

The three functions answer three different questions about the same range. COUNT only tallies cells holding numbers (including dates, which are stored as numbers) — text like "pending" is invisible to it. COUNTA counts every cell with anything in it: numbers, text, even an error value. COUNTBLANK counts the truly empty cells. On a column containing 250, an empty cell, "pending", 180, and another empty cell, they return 2, 3, and 2 respectively — and COUNTA plus COUNTBLANK equals the total rows, a handy sanity check. The classic confusion is running COUNT on a text column, getting 0, and concluding the data vanished; the data is fine, you just asked for numbers.

COUNTA

Counts every non-empty cell — the "how many rows are filled in" answer.

A2:A50

The same range works in all three: =COUNT(A2:A50) for numbers, =COUNTBLANK(A2:A50) for gaps.

When to use it

COUNTA for how many survey responses or orders exist, COUNT for how many have a numeric amount, COUNTBLANK to find how many entries are still missing before a deadline.

Common mistakes

• ✕COUNT on a text column returning 0.

  ✓COUNT only sees numbers, so a column of names returns 0 even when full. Count entries with =COUNTA(A2:A50) instead.

• ✕A single space defeating COUNTBLANK.

  ✓A cell holding just " " looks empty but isn't — COUNTA counts it and COUNTBLANK skips it. Clear phantom spaces (Ctrl+H, replace " " with nothing) before trusting the numbers.

• ✕Formulas returning "" muddying both counts.

  ✓A formula result of "" is counted by COUNTA (there is a formula in the cell) and by COUNTBLANK (the value is empty), so the two can overlap. For data columns, prefer real blanks or a visible label over "".