Getting Rid of Zeros

  • Thread starter Thread starter JimS
  • Start date Start date
J

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
 
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.
 
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.
Click to expand...
 
Back
Top