Thread: Cell to return blank not 0
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
  
Posts: 143
Default Cell to return blank not 0
Try =IF(SUM(B4:B13),SUM(B4:B13),"")

I've never come across that one before, works great!

.... unless, of course, there are numbers in B4:B13 but the sum happens to
be zero by coincidence.
Reply With QuoteReply With Quote