Return cell blank ifsum=0

[Guest]

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]

I'd use:

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

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

 

[David Biddulph]

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

 

[Guest]

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.

 

[Peo Sjoblom]

Use NA()

as an example instead of


=IF(A1=0,"",A1)

use

=IF(A1=0,NA(),A1)


The formula will show as #N/A but the chart will show as null and if you
don't like the look of the #N/A you can hide it with conditional formatting
using white fonts

 

[Guest]

The NA bit worked but the chart is still seeing something there...

How do I do the condition formatting ??

Regards

Mark