View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Return cell blank ifsum=0

I'd use:

=if(sumif(...)=0,"",sumif(...))

Did you really mean to use F:G???

Mark Allen wrote:

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


--

Dave Peterson