Documentation/Calc Functions/COUNTBLANK

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

COUNTBLANK

Category:

Statistical Analysis

Summary:

Returns the number of empty cells.

Syntax:

COUNTBLANK(Range)

Returns:

Returns the number of empty cells in the cell range Range.

Arguments:

Additional details:

Examples:

=COUNTBLANK(A1:B2) returns 4 if cells A1, A2, B1, and B2 are all empty.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: