Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Information Functions

 

Return the total number of error values in a range named Data

Input the formula: {=SUM(IF(ISERROR(Data),1))}, and Shift+Control+Enter