Return the number of blank cells in column A : COUNTBLANK « Statistical functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =COUNTBLANK(A:A)
Input the formula: =COUNTBLANK(A:A)
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