Stat · Nov 16, 2026

The COUNTBLANK function,
measured & explained.

COUNTBLANK counts the gaps: cells that are truly empty, plus cells whose formula evaluates to empty text (""). It is the complement of COUNTA — together they add up to the number of cells in the range. A cell containing a space, a zero or an error is NOT blank, which is the distinction that trips most people up.

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

How COUNTBLANK works

Returns a number. Counts empty cells and "" formula results; spaces, zeros and errors are not blank.

=COUNTBLANK(range)
rangeThe range in which to count empty cells.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — What is a blank?

Empty vs looks empty

Only true emptiness counts. Click any row to load it.

Counting the gaps

ExpressionResultWhy
=COUNTBLANK(A2:A8)1The single empty score cell
=COUNTBLANK(C2:C8)0No empty labels
=COUNTBLANK(A2:C8)1One gap across the block
=COUNTA(A2:A8)6Non-empty complement
=COUNTBLANK(B2:B8)0Sales column is full
=ROWS(A2:A8)-COUNTA(A2:A8)1Total minus non-empty
⚠ A space " ", a zero 0 and an error value are all non-blank. Only an empty cell or a formula returning "" counts. COUNTBLANK(A2:A8)=1 here, not 2.
COUNTBLANK + COUNTA = total cells. COUNTBLANK counts empty cells and "" results; it does not count spaces, zeros or errors.
// 03 — Try it live

Interactive COUNTBLANK playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to count gaps and cross-check against COUNTA.

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 COUNTBLANK works

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

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

Master stat

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

  • Counts true emptiness and "" results
  • Spaces/zeros/errors are non-blank
  • COUNTBLANK+COUNTA=total cells
  • Single range argument only
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked