Return the total number of error values in a range named Data : ISERROR « Information functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Information functions
  3. ISERROR
Input the formula: {=SUM(IF(ISERROR(Data),1))}, and Shift+Control+Enter
17.6.ISERROR
17.6.1.ISERROR returns TRUE if the value is any error valueISERROR returns TRUE if the value is any error value
17.6.2.Return the total number of error values in a range named Data