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
|