MS Excel: CountBlank Function
In Excel, the CountBlank function counts the number of empty cells in a range.
The syntax for the CountBlank function is:
CountBlank( range )
range is the range of cells to count empty cells.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:

Based on the Excel spreadsheet above:
=CountBlank(A1:A4) would return 1 =CountBlank(A1:A6) would return 3 =CountBlank(A1:B4) would return 3