The formula works but unfortunatley the blank response is showing as blank
but I am then using dynamic charting and it still shows as 0...I need the
cell to show nothing so it see's the cell as completly blank !!!!!

Help please.

"David Biddulph" wrote:

=IF(SUMIF(F:G,L29,G:G)=0,"",SUMIF(F:G,L29,G:G))
--
David Biddulph

"Mark Allen" wrote in message
...
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