Thread: simple sum unless blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cheryl Cheryl is offline
external usenet poster
  
Posts: 144
Default simple sum unless blank
simple formula j1-i1 but when I expand down the column I want it to return 0
or leave empty if a cell is blank. Can you help me?


--
Cheryl
Reply With QuoteReply With Quote