sum if statement

[Kim Shelton at PDC]

My formula in Column D should read =sum(d6+c7=d7) but if c7 is blank then i
want the answer to be blank in column D7

column
C6 D6
5 10
c7 D7
0 leave blank.(not even a zero)

 

[Dave Peterson]

You can make the cell look blank with:
=if(c7="",sum(d6,d7,c7))
or
=if(c7="",d6+d7+c7)

You don't need =sum() and the + signs.

 

[Kim Shelton at PDC]

Still puts o in d7
if c7 is blank that I don't want the formula in d7 to calculate not even a
zero

any other ideas????

 

[Dave Peterson]

Sorry, I had a couple of typos.

=if(c7="","",sum(d6,d7,c7))
or
=if(c7="","",d6+d7+c7)