Good morning,

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

=IF(ISERROR(SUM(O4:Q4))," ",SUM(O4:Q4))
I have also tried this

=IF(Q3>0,SUM(O3:Q3)," ")
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