IFISError or Equivalent on a Zero Value

[djfatboyfats]

Good morning,

I need a formula that will give me a null value if the sum adds up to zero.

Please Login or Register  to view this content.

I have also tried this

Please Login or Register  to view this content.

The reason I don't want the value of zero is because if the value 0 (Zero) are there then it counts in the rank, but i only want it to count if the rank if there is data and not zeros.

Thanks in advance

DJ

[martindwilson]

=if(sum(o4:q4)=0,"",sum(o4:q4))

[djfatboyfats]

That's done the trick. Thank you

[arlu1201]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.