Documentation/Calc Functions/COUNTBLANK

From The Document Foundation Wiki
Jump to navigation Jump to search


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.

Examples:

Formula Description Returns
=COUNTBLANK(A1:A4) where cells A1, A2, B1, and B2 are all empty The function counts all the empty cells 4
=COUNTBLANK(A1:A4) where A1, A2, A3, A4 contain 120, nothing(empty cell), 0, Err:502 The function does not count 0, error values and numbers, counting only the empty cell. 1

Related LibreOffice functions:

COUNT

COUNTA

COUNTIF

COUNTIFS

ISBLANK

ODF standard:

Section 6.13.8, part 2

Equivalent Excel functions:

COUNTBLANK