# Manuals/calci/COUNTBLANK

**COUNTBLANK ()**

- Parameter is the range of cells or array of data.
- COUNTBLANK(), counts the number of blank cells within a range.

## Description

COUNTBLANK()

- Data may contain numbers, characters, text, dates, logic values, error values, empty text or blank cells etc.
- 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

## See Also

## References