My formulas keep giving me #value! how can i stop it

[tonywatsonhelp]

Hi Everyone,
I think i must be missing something simple but i keep getting the #value! error in my sums?

as an example

"=AB11+CX11+BA11-CZ11-DA11"
works great when every cell has a number or zero in it but #values! out if one or more cells are empty or return the ""
i cant believe this is supposed to happen? so am i doing something wrong? is there a way to stop it happening?

please help using the above as the example

Thanks

Tony

 

[Toadstool]

Hi TonyWatsonHelp,

Try =NUMBERVALUE(AB11)+NUMBERVALUE(CX11)+NUMBERVALUE(BA11)-NUMBERVALUE(CZ11)-NUMBERVALUE(DA11)

 

[Zot]

=IFERROR(AB11+CX11+BA11-CZ11-DA11,"")

 

[MARK858]

Try

=SUM(AB11,CX11,BA11)-SUM(CZ11,DA11)

 

[tonywatsonhelp]

Hi Everyone,
Thanks for the input Zot but that only hides the error,
Mark858 this is a great idea, thank you,
Toadstool, this is perfect, it is exactly what i need and can be used in more than just this thanks everyone
Tony

 

[MARK858]

You're welcome, happy we helped.