I recently came across a great way of counting how many errors are contained in an Excel worksheet. I thought this would be great if you have a large worksheet with multiple calculation types, to quickly assess if you have any of those errors that Excel sometimes throws at us.
With this peachy little formula we can, in a flash, count the errors, and then decide if we want to ignore them or deal with them!
I have in my example a sheet that has a good few calculations on it. I then wanted to look at all of my cells in the work area (in this instance it is the area A2:D50) and see if any of my cells were returning an error.
In cell I2 I have used the formula
In the case of my example I have listed errors- good job!
Other Excel Formula Links You Might Like
Have you come across this formula yourself before?
Do you have a better way of carrying out this task in Excel? Let me know so we can share with our other Excellers!