Thread: Return cell blank ifsum=0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark Allen Mark Allen is offline
external usenet poster
  
Posts: 54
Default Return cell blank ifsum=0
I am using this formula

=SUMIF(F:G,L29,G:G)

normal answer is for instance 33456
sometime the answer is 0
When the answer is 0 I want the cell to show nothing at all

Is this possible ???

Regards

Mark
Reply With QuoteReply With Quote