Getting Rid of Zeros

[JimS]

s20 u20 v20

1 2 3
0
0
4 5 9
0
0


The following formula sums s20+u20 in v20:

=IF(S20="","",SUM(S20+U20))

However, in s21,u21, s22, u22, s23, u23, s25, u25, s26, u26, etc. the
value calculated is "false". When those rows are sumed it returns a
zero in the V column.

I've used conditional formatting to get rid of the falses. I want to
get rid of he zeros in the V column, but I can't use conditional
formatting because sometimes the answer might contain a zero.

Is there a way to get rid of the zeros by altering the formula?

Thanks

 

[Dave Peterson]

Maybe...

=if(isnumber(s20),s20+u20,"")

or

=if(count(s20,u20)=2,s20+u20,"")
(if you wanted both cells to be numbers before showing the sum.)

The =sum() function isn't required.

 

[JimS]

Thanks, Dave...both work fine. Appreciate it.

Maybe...

=if(isnumber(s20),s20+u20,"")

or

=if(count(s20,u20)=2,s20+u20,"")
(if you wanted both cells to be numbers before showing the sum.)

The =sum() function isn't required.