COUNTBLANK counts the number of blank cells within a range : COUNTBLANK « Statistical functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =COUNTBLANK(A2:B5). Press Enter to get the result.
Input the formula: =COUNTBLANK(A2:B5)
21.13.COUNTBLANK
21.13.1.COUNTBLANK counts the number of blank cells within a rangeCOUNTBLANK counts the number of blank cells within a range
21.13.2.Return the number of blank cells in column AReturn the number of blank cells in column A
21.13.3.Returns the number of empty cells on the entire worksheet named Sheet1Returns the number of empty cells on the entire worksheet named Sheet1