How could I forget this formula? Help please

S

Scuba Wino

Good afternoon,

Alright, here's a simple one. How I have forgotten it (when I use it
almost every day) is beyond me. All I know is that my mind is mush
right now.

I am preparing a blank work sheet for others to use, so here it is:

I have multiple columns that all sum different cells. I need the
"Answer" cell to not show a 0 if there is nothing to "sum".

ex. Cell A1 is the sum total of A2-A10. If A2-A10 are empty, I do NOT
want A1 to show 0.

I have no idea how I am forgetting this today. I need a drink.

Thanks for your help. Really.
 
S

Scuba Wino

SLAnt said:
=IF(COUNTA(A2:A10)=0,"",SUM(A2:A10))

somethinglikeant
Click to expand...

Didn't work. That is not the one I'm used to using so I tried it and
it gave me an error code.

Thanks for trying. My brain is mush, I need wine.
 
R

reybie

=IF(SUM(A2:A10)=0,"",SUM(A2:A10))
Long formula, I'm sure there's something simpler
 
P

Pete_UK

A1 could contain the formula =SUM(A2:A10) and you could apply
conditional formatting to this cell such that if the cell contents is 0
set the foreground colour to the background colour so that nothing
shows.

Hope this helps.

Pete
 
G

gary-in.biz

Scuba said:
Good afternoon,

Alright, here's a simple one. How I have forgotten it (when I use it
almost every day) is beyond me. All I know is that my mind is mush
right now.
Click to expand...

=IF(A5<A66,0,$C$5)

I use this in one of my sheets... if a5 is less than a66, then just put
a 0 there, but if a5 is greater than a66, then put in the value of c5
 
S

Scuba Wino

Thanks everyone for their help. I really appreciate you taking the tim
out to help me. I got now. My mind is a little better today.

Thanks again everyone. It's nice to know someone is out there when yo
need them
 
Top