Stat · Nov 16, 2026

The COUNT function,
measured & explained.

COUNT tells you how many of its arguments are numbers. In a range it counts numeric cells and skips text and blanks — the right tool for 'how many responses did we actually get?'. COUNTA counts anything non-empty and COUNTBLANK counts empties; confusing the three is the most common counting mistake.

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

How COUNT works

Returns a number. Counts numeric cells and numeric literals; text and blanks in ranges are ignored.

=COUNT(value1, value2, ...)
value1The first item, reference or range to count numbers 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 — The counting trio

COUNT vs COUNTA vs COUNTBLANK

5 numbers + 1 blank + 1 text, read three ways, measured live. Click any row to load it.

Count trio, measured

ExpressionResultWhy
=COUNT(A2:A6)5Five numeric scores
=COUNT(A2:A8)5Blank and text ignored
=COUNTA(A2:A8)6Counts the text cell too
=COUNT(B2:B8)7All seven sales numeric
=COUNT(85,"text",92)2Typed text ignored
=COUNT(A2:A4)3First three scores
=COUNTBLANK(A2:A8)1One blank cell
=COUNT(C2:C8)0All-text range
⚠ COUNT ignores stored-as-text numbers: a column of "85" as text counts 0. Convert with VALUE, or use COUNTA if you only need non-empty.
COUNT + COUNTBLANK = COUNTA on the same range (5 + 1 = 6). COUNT counts numbers, COUNTA non-empty, COUNTBLANK empty.
// 03 — Try it live

Interactive COUNT playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to compare COUNT, COUNTA 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 COUNT works

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

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

Master stat

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

  • COUNT numbers, COUNTA non-empty, COUNTBLANK empty
  • COUNT+COUNTBLANK=COUNTA
  • Stored-as-text numbers count 0
  • Dates count as serials
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked