Using Sumproduct Unable to remove duplicate ranking

[yaetis]

A Manager	B Employee	C Salary	D Comparative Ranking
John	Employee 1	10000	2
John	Employee 2	10000	2
Rob	Employee 3	35000	1
Rob	Employee 1	0	3
Rob	Employee 2	0	3
Smith	Employee 1	60002	1
Smith	Employee 3	50000	2
Smith	Employee 2	0	3

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

I want to get a comparative Ranking within each Manager,So for example , I wan to check with John, how his employees are ranked basis on Salary they are getting, For some record the Salary is 0 as well.
For Column D , i have used flat Sumproduct , =SUMPRODUCT(--(A3=$A$3:$A$10),--(C3<=$C$3:$C$10)), but this doesn't take care of Duplicates. I have tried various flavours using , Index as well, But no Luck as well.

 

[VBA Geek]

d2 =COUNTIFS($A$2:$A$9,A2,$C$2:$C$9,">"&C2)+COUNTIFS(A$2:A2,A2,C$2:C2,C2)

Manager	Employee	Salary	Comparative Ranking
John	Employee 1	10000	1
John	Employee 2	10000	2
Rob	Employee 3	35000	1
Rob	Employee 1	0	2
Rob	Employee 2	0	3
Smith	Employee 1	60002	1
Smith	Employee 3	50000	2
Smith	Employee 2	0	3

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[yaetis]

d2 =COUNTIFS($A$2:$A$9,A2,$C$2:$C$9,">"&C2)+COUNTIFS(A$2:A2,A2,C$2:C2,C2)

Manager	Employee	Salary	Comparative Ranking
John	Employee 1	10000	1
John	Employee 2	10000	2
Rob	Employee 3	35000	1
Rob	Employee 1	0	2
Rob	Employee 2	0	3
Smith	Employee 1	60002	1
Smith	Employee 3	50000	2
Smith	Employee 2	0	3

<tbody>
</tbody>

Works like a Charms, I was so dumbStuck with Sumproduct , totally ignored the awesomeness of Countif..
Thanks a lot !