Conditional blank cell with a sum 2

[Hacim]

Using Excel 2002 sp3

I am trying to create a formula that will keep the cell with the range total, blank until a number has been input into the cell that is been summed.
This is what I have tried with no sucess.
=IFSUM(B28)=" "," ",SUM(B17:B28)
Thanks for any help.

 

[bluedragon2]

=IF(SUM(B17:B28)=0,"",SUM(B17:B28))

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Hacim]

Now I am getting a #VALUE in the cell when I try this formula =IF(SUM(J28)=0,"",SUM(J17:J28))/1000

 

[AnotherHiggins]

You can't divide ""/1000. That is like dividing cat/1000. It just doesn't make sense.

Instead of returning "", return 0.

Also, if you are only testing a single cell, there is no need for the SUM.

Try this:

=IF(J28=0,0,SUM(J17:J28))/1000

What is in J28? Is that a formula summing J17:J28?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[bluedragon2]

=IF(SUM(J17:J28)=0,"",SUM(J17:J28)/1000)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Hacim]

Since I was only evaluating one cell as anotherhiggins mentioned, I used his formula =IF(J28=0,0,SUM(J17:J28))/1000
and went to the tools-options- view tab and unchecked "zero values" so any cell with a zero value would be blank. (which is what my anal boss requested) Thanks