Formula Help adding 2 cells from another Sheet

[zone709]

I ran into this problem today. If i use this formula if one of the cells is empty or has a word in it. It returns nothing, but if i add a 0 in one of the empty cells or one that has a word in it. Then it returns the sum no problem.
It wont return if one cell is empty basically. I have to add a 0 in it to work. I need a work around formula in anyone can help thanks.

=IFERROR(Sheet1!N3+Sheet1!U3,0)

 

[Fluff]

How about

=sum(Sheet1!N3,Sheet1!U3,0)

 

[zone709]

Perfect thanks

 

[Fluff]

You're welcome & thanks for the feedback.