# Manuals/calci/COUNTBLANK

# COUNTBLANK(r)

- Where 'r' is the range of cells or array of data.

- COUNTBLANK() returns the number of empty cells or blank cells within a given range.

- Data may contain numbers, characters, text, dates, logic values, error values, empty text or blank cells etc.

## Description

COUNTBLANK(r)

For example, COUNTBLANK(23,45,,"EVEN") *returns 1 * as a result.

COUNTBLANK(56,"","4/4/2013",,TRUE) *returns 2 * as a result.

- This function calculates empty cells or blank values in a particular range of cells.

- Cells with empty texts are counted but cells with zero values are not counted.

- COUNTBLANK() also calculates the cells with formulas that return an empty text ("").

- COUNT() can be used to count the non-empty or non-blank cells in the given range except logical values, error values and text.

## Examples

Consider the following table with different types of data in various columns.

COUNTBLANK() counts the number of blank or empty cells in the given range.

5 | 3 | |

16 | 0 | TRUE |

4/4/2011 | 0 | |

4 | 14 | =IF(C3=0,"",C3) |

=COUNTBLANK(A1:A4) : Counts the number of cells with blank values or empty cells in the range A1 to A4, *returns 2* as a result.

=COUNTBLANK(A1:A4,5,"") : Counts the number of cells with blank values or empty cells in the range A1 to A4,a number '5' and blank ("") *returns 3* as a result.

=COUNTBLANK(B2:B4) : Counts the number of cells with blank values or empty cells in the range B2 to B4, *returns 0* as a result. value '0' in B2 cell is considered as a non-blank value.

=COUNTBLANK(C1:C4) : Counts the number of cells with blank values or empty cells in the range C1 to C4, *returns 1* as a result. The IF() function returns a blank value in cell C4.

## Related Videos