countblank

Count empty cells in a range.

Syntax

v = countblank(range)

Description

Returns the number of empty cells in range. Cells with a formula returning "" are counted as blank; truly blank cells (never written) are also counted.

Example

countblank(A1:A100)

See also

• counta — Count non-empty values in the arguments.
• count — Count numeric values in the arguments.