Stop Sum blanks

[Guest]

I am using the Sum function. My range has blank cells. I am entering 0 for
No. If I get a Sum of 0 then I have an answer of False. But how do I stop
Excel from displaying 0 when the range of cells is left blank?

 

[Dave Peterson]

Maybe...

This checks for at least one number in A1:A10:
=if(count(a1:a10)=0,"No Values",sum(a1:a10))

This checks for numbers in all of the cells in A1:A10
=if(count(a1:a10)<10,"Some Numbers Missing",Sum(a1:A10))

 

[Guest]

Dave,

I played around with the formulas that you gave me and came up with
=IF(SUM(G1,I1,K1)=0,"",SUM(G1,I1,K1))

When G1,I1,K1 are blank, I get a blank cell instead of 0. This is what I
want. However, when G1,I1,K1 have a value of 1, I also get a blank cell.
What can I do to get the latter part of the formula to SUM.

 

[Guest]

Dave,

I figured it out. The formula is right. I made a mistake with cell
references. Thanks for your help.