Hi


you can replace your formula with 
=iferror(old_formula,0)
this will convert all error values to zero..

Cheers!!