Skip to content

COUNTBLANK

StatisticalExcel 2007

Count empty cells in a range.

Syntax

COUNTBLANK(range)

Examples

=COUNTBLANK(B2:B100)

→ missing entries

Related functions

COUNTAISBLANK

More Statistical functions

AVEDEVAVERAGEAVERAGEAAVERAGEIFAVERAGEIFSBETA.DISTBETA.INVBINOM.DISTBINOM.DIST.RANGEBINOM.INVCHISQ.DISTCHISQ.DIST.RT

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.