# COUNTBLANK(r)

• Where r is the range of cells.
• COUNTBLANK() returns the number of empty cells or blank cells within a given range.

## 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 ("").

## 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 in the range A1 to A4 with blank values or empty cells, returns 2 as a result.

=COUNTBLANK(B2:B4) : Counts the number of cells in the range B2 to B4 with blank values or empty cells, 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 in the range C1 to C4 with blank values or empty cells, returns 1 as a result. The IF() function returns a blank value in cell C4.