HELP - I have several cells I want to sum but am getting the #VALUE error. This is because some of the cells contain an IF formulae to avoid getting the #ERROR value when dividing by 0.

I have tried just using simple =C3+A3+I3 or =sum(C3+A3+I3).