I have listed down the types of error in excel and their likely causes in the table below:
Error type can be found out through the formula =Error.Type(cell_ref)
Count instances of error
One of the ways to count the total occurence of error in an area is this
{=SUM(IF(ISERROR(B2:B8),1,0))} entered as an array formula with ctrl+shift+enter
In the above example it returns 7
Replace error with a dash
If a formula gives you an error for certain input parameters and you do not want these to show up on excel sheet, you could use this function
=IF(ISERROR(formula),”-“,formula)
We have used this in creating spaces within a list using indirect function
Let me know if you need any help with these errors. Have fun handling errors 🙂
Useful Excel Tips 