Help with Ranking formula

i have a sheet that ranks employee sales. It works fine, but i would like it to be capable of ranking persons with 0 sales at the bottom of the rank list, but rank everything else normally. Is this possible without using any VBA?
my current formula is:

Please Login or Register  to view this content.

Is this what you mean

=IF(R4<>0,RANK(R4,$R:$R,)+COUNTIF($R$4:R4,R4)-1,COUNT(R:R)-COUNTIF(R:R,0)+1)

well that formula produces repeat ranks. Also i should have mentioned that "I4" is the location of the 0 condition mentioned before.
so where you plced "R4<>0" it would be "I4<>0".

thank you for your response.

Originally Posted by mttp1990

well that formula produces repeat ranks.

And is that what you wanted, your original request was not clear to me.

Originally Posted by mttp1990

Also i should have mentioned that "I4" is the location of the 0 condition mentioned before.
so where you plced "R4<>0" it would be "I4<>0".

I used R4 because that is what you used in your formula, and you are ranking the values in column R, so I fail to see the relevance of I4.