View Single Post
  #1   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?


Hi all,

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

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