Stop Sum blanks

R

renee

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?
 
D

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))
 
R

renee

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.
 
R

renee

Dave,

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