Mega Code Archive

 
Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions
 

Returns the number of empty cells on the entire worksheet named Sheet1

Input the formula: =COUNTBLANK(Sheet1!1:1048576)