# Documentation/Calc Functions/COUNTBLANK

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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:

## ODF standard:

## Equivalent Excel functions:

COUNTBLANK