Count cells with error values
In this module:
- Count the number of error values in a worksheet
- #N/A
- #NUM!
- #REF!
- #NAME?
- Using selected IS functions (ISERROR, ISERR, and ISNA) and COUNTIF function
The sample data set is the range B5:E8 shown in figure 1. The formulas in column B, rows 13 to 32 are displayed in column C. For details of the double negation operator used in cell B10 (=SUMPRODUCT(--ISERROR(ErrData))) see entering-and-editing-worksheet-data
- Related material Excel cell errors 1 to 7
- Development platform: Excel 2016 (64 bit) Office 365 ProPlus on Windows 10
- Revised: Saturday 25th of February 2023 - 10:12 AM, [Australian Eastern Time (AET)]