ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / STATISTICAL

COUNTBLANK Excel function

Counts blank cells.

Correct sentence to use

Count blank cells in [range].

Modify this query in PlainFormula →

Example formula

=COUNTBLANK(A2:A25)

Counts blank cells.

Syntax

COUNTBLANK(range)

Argument signature: range

Availability note

Commonly available in current Excel; verify platform and locale-specific behaviour.

Check Microsoft's Excel function documentation ↗

← Browse all functions