Returns the number of empty cells on the entire worksheet named Sheet1 : COUNTBLANK « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. COUNTBLANK
Input the formula: =COUNTBLANK(Sheet1!1:1048576)
Input the formula: =COUNTBLANK(Sheet1!1:1048576)
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