Thread: How to sum cells but not show zero if cells are blank?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Simon Lloyd
 
Posts: n/a
Default How to sum cells but not show zero if cells are blank?

Thanks for the speedy reply both!, it did help alot, but i have one
other problem, i need the statement to be an or statement i.e
=IF(SUM(P5:Q5)=0,"",SUM(R4-P5+Q5)) needs to be something like
=IF(SUM(P4)=0,(IF(SUM(Q4)=0,"",SUM(R3-P4+Q4)))) but this returns a
value FALSE, it needs to say if P4 is 0 then sum R3+Q4 or If Q4 is 0
then sum R3-P4 Or if there are values in both then R3-P4+Q4 and of
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,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=549933

Reply With QuoteReply With Quote