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.
"Dave Peterson" wrote:
[Quoted Text] > 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))
>
>
>
>
>
> renee wrote:
> >
> > 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
>
|