How to sum cells but not show zero if cells are blank?

S

Simon Lloyd

Hi all,

can anyone tell me how to sum cells without showing zero if cells ar
blank?

regards
Simo
 
R

Ron Coderre

Simon:

Perhaps something like this:

A21: =IF(COUNT(A1:A20)=0,"",SUM(A1:A20))

If there are NO numbers in A1:A20, the formula returns "" (effectively
a blank). Otherwise, it returns the total.

Does that help?

Regards,
Ro
 
P

Paul B

Simon, here is one way,

=IF(SUM(A1:A10)=0,"",SUM(A1:A10))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Simon Lloyd" <[email protected]>
wrote in message
news:[email protected]...
 
S

Simon Lloyd

Thanks for the speedy reply both!, it did help alot, but i have on
other problem, i need the statement to be an or statement i.
=IF(SUM(P5:Q5)=0,"",SUM(R4-P5+Q5)) needs to be something lik
=IF(SUM(P4)=0,(IF(SUM(Q4)=0,"",SUM(R3-P4+Q4)))) but this returns
value FALSE, it needs to say if P4 is 0 then sum R3+Q4 or If Q4 is
then sum R3-P4 Or if there are values in both then R3-P4+Q4 and o
course if there are no values in P4,Q4 then dont show zero!

Phew! its clear as mud to me hope you can sort the muddle!

regards,
Simo
 
Top