Information Functions MSOfficeExcel 2007 Tutorial

Input the formula: =SUM(IF(ISNONTEXT(Data),1)), and press Shift+Control+Enter