Documentation/Calc Functions/COUNTBLANK

Function name:
COUNTBLANK

Category:
Statistical Analysis

Summary:
Returns the number of empty cells from the given range of cells.

Syntax:
COUNTBLANK(Range)

Returns:
Returns a non-negative integer which is the number of empty cells in the cell range Range.

Arguments:
Range is a reference to the range of cells from which empty cells need to be counted.

Additional details:
The function counts that case where a cell formula gives "", empty text but it doesn't count cells with 0 value.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/COUNT COUNT]

[[Special:MyLanguage/Documentation/Calc_Functions/COUNTA COUNTA]

[[Special:MyLanguage/Documentation/Calc_Functions/COUNTIF COUNTIF]

[[Special:MyLanguage/Documentation/Calc_Functions/COUNTIFS COUNTIFS]

[[Special:MyLanguage/Documentation/Calc_Functions/ISBLANK ISBLANK]

ODF standard:
Section 6.13.8, part 2

Equivalent Excel functions:
COUNTBLANK