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






Input the formula: =SUM(IF(ISNA(Data),1)), and Shift+Control+Enter
17.9.ISNA
17.9.1.ISNA returns TRUE if the value is the #N/A error valueISNA returns TRUE if the value is the #N/A error value
17.9.2.Return the total number of #NA error values in a range named Data