0's to blank

[Treeskier]

Hi,
I'm summing from several sheets and some don't yet have entries. On my
total sheet I want those cells that yet to have a value to show blank and
not a 0. How can I accomplish this?
Thanks for your help!

 

[Treeskier]

Hi Don, " I'm a newbie or less"
This is from my total sheet and adds all entries from the next 21 sheets, so
far, into this cell. A 0 appears in the total of a cell if there is no
entries in any of the other 21 cells. I just want nothing to appear in the
totals cell if nothing has been entered. (formula below)
Thanks in advance

=SUM('Sheet 1:Lastsheet'!P52)

 

[Earl Kiosterud]

Treeskier,

On your summary sheet you can use Tools - Options - View - uncheck Zero
values. Or you can format that cell not to show zero totals -- Format -
Cells - Custom:

General;General;
0.00;-0.00;
0.00;(0.00;

The first section is formatting codes for positive values, the second for
negative, the third for zero -- hence the second semicolon.

 

[Peo Sjoblom]

Try

=IF(COUNT('Sheet 1:LastSheet'!P52),SUM('Sheet 1:LastSheet'!P52),"")

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Treeskier]

Hi Peo,
This seems to blank the whole column whether it's a 0 or a 5,6, so on!

 

[Peo Sjoblom]

Maybe I misunderstood, my formula will return a blank if all P52 in all 21
sheets are blank,
as soon as a number is entered in any of the 21 P52 it will sum.
--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[RagDyer]

Works fine for me.
Make sure you've copied everything correctly!

BTW,
Doesn't what happened to Sonny Bono kind of turn you off from doing what
your handle implies?
--

Regards,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi Peo,
This seems to blank the whole column whether it's a 0 or a 5,6, so on!

 

[Treeskier]

That's because I did a Bono but didn't die!!!!

Works fine for me.
Make sure you've copied everything correctly!

BTW,
Doesn't what happened to Sonny Bono kind of turn you off from doing what
your handle implies?
--

Regards,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi Peo,
This seems to blank the whole column whether it's a 0 or a 5,6, so on!

 

[RagDyer]

So did I .. SO ... now it's powder ABOVE the tree line only!

That's because I did a Bono but didn't die!!!!

 

[Peo Sjoblom]

Maybe you mistook a tree line for a corn line, you are still in IL, right?
<g>

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[RagDyeR]

If I understand you Peo, you keep thinking I'm a Polak from Chicago.
I'm a Polak, born in NY, and now swim and ski and dye (among a lot of other
things), in CA.<bg>

Maybe you mistook a tree line for a corn line, you are still in IL, right?
<g>

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Peo Sjoblom]

Oops! Must be me associating Polaks with Chicago, I apologize.. I am sure
you can find some trees in CA unless
they have all been burnt down in those fires..

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Dave Peterson]

Maybe you're confused with other Swedes in Illinois.

 

[Treeskier]

Well, Rag, I too would stay above and out of the tree line, but I really did
do the same as Bono and was instantly paralyzed, so I haven't been back up.
Though I will try again at the same place (Alpine Meadows CA.) they have a
great disabled ski school! I still need to get back up there and find my
other ski and my glacier glasses. You think they would still be up in a tree
somewhere after 9 years?

 

[RagDyeR]

Sorry to hear that it was that serious.
Mine was just a popped ACL.

Down here in the south, I go to an annual event for disabled skiers at Bear
Mountain, located in the Big Bear Lake area.

It is unbelievable what I see these folks do, both the amputees and the
partially paralyzed.

I wish you all the luck!
--

Regards,

RD


Well, Rag, I too would stay above and out of the tree line, but I really did
do the same as Bono and was instantly paralyzed, so I haven't been back up.
Though I will try again at the same place (Alpine Meadows CA.) they have a
great disabled ski school! I still need to get back up there and find my
other ski and my glacier glasses. You think they would still be up in a tree
somewhere after 9 years?