Ranking Positive/Negative but Not Zeros?

[AboveBeyond]

I'm can't figure out how to do this?

Excel Workbook
	N	O	P
23		Sales	Rank
24	John	500	3
25	Bob	300	4
26	Larry	750	2
27	Mary	900	1
28	Joe	0
29	Bob	-500	5
Sheet

 

[iggydarsa]

put this formula in P24 and drag down

=IF(O24<0, RANK(O24,$O$24:$O$29) - COUNTIF($O$24:$O$29,0), IF(O24=0, "", RANK(O24,$O$24:$O$29)))

 

[AboveBeyond]

That worked, thank you iggydarsa!