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

COUNTBLANK