Statistical Functions MSOfficeExcel 2007 Tutorial

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