How to Count Cells with Errors in Excel. Count Specific Error eg #N​/A or Count All Errors

Microsoft Excel Tips and Tricks

I demonstrate how to count the number of cells that contain an error. You can either count how many cells contain a specific error such as the #N​/A error or you can count the numbers of cells that contain any type of error.

Credit Chester Tugwell