Returns the number of empty cells from the given range of cells.
Returns a non-negative integer which is the number of empty cells in the cell range Range.
Range is a reference to the range of cells from which empty cells need to be counted.
The function counts that case where a cell formula gives "", empty text but it doesn't count cells with 0 value.
|=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:
Equivalent Excel functions: