Sum If = 0 but this ruins graph

[Plumbstar Tom]

Hi I have this formula in use

=SUMIF($D$22:$D$222,"=Sales",H22:H222)

But if the result is 0 then on my dynamic chart it upsets the chart as it results in an answer of zero meaning the chart has a value to work on

Is there any way I can do SUMIF but if the result is 0 then do not do SUMIF calculation so to speak?

 

[VoG]

Try

=IF(SUMIF($D$22:$D$222,"Sales",H22:H222)=0,NA(),SUMIF($D$22:$D$222,"Sales",H22:H222))

 

[number kruncher]

You can wrap your original formula in another IF statement, which if value = 0 then result is #N/A, e.g.

=if(SUMIF($D$22:$D$222,"=Sales",H22:H222)<>0,SUMIF($D$22:$D$222,"=Sales",H22:H222),#N/A)

HTH

 

[Plumbstar Tom]

I tried and it worked perfectly

i'll tidy it up now with a conditional format for my table

Thanks VoG