Related Functions:

The COUNTBLANK function returns the number of blank cells in a supplied range of cells.

Syntax

=COUNTBLANK(range)

Arguments

Argument Description
range The range of cells from which you want to count the blank cells

Examples

  A B C D D E
1 Data Data   Formula Result Notes
2 text     =COUNTBLANK(A2:B5) 3 Counts empty cells in the range supplied
3   FALSE   =COUNTBLANK(A4:D5) 7  
4 6 54        
5 12