Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Information Functions
Counting Nontext Cells
Input the formula: =SUM(IF(ISNONTEXT(Data),1)), and press Shift+Control+Enter