0's to blank

T

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!
 
T

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

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

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
 
P

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
 
R

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!
 
T

Treeskier

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

RagDyer said:
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!
Click to expand...
 
R

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!!!!
 
P

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
 
R

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
 
P

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

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

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