Skip to Content

COUNTBLANK

Counts the number of blank cells within a range

Syntax

COUNTBLANK(range)

Parameters

  • range: Required. The range from which you want to count the blank cells

Example

=COUNTBLANK(A1:A10)
Returns: NumberSince: Excel 2003