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