Multiple Criteria Rank With Sumproduct

[xlmaniac]

Dear All,
I do have a sample data-set across A1:C8 as follows.
In Column D, I have put my desired result(conditional rank with multiple criteria).
In column E, I have tried to populate the result with Sumproduct function, but it is yielding 1,
Could someone help me in re-constructing the formula with SUmproduct.
My formula in E1=SUMPRODUCT(--($A$2:$A$8=A2),--($B$2:$B$8=B2),--(C2<$C$2:$C$8))+1
Pls help.

Name	Department	Score	Rank-desired Result	Result With Sumproduct
A	Science	80	2	1
B	Science	75	3	1
C	Science	95	1	1
D	Commerce	60	3	1
E	Commerce	55	4	1
F	Commerce	70	2	1
G	Commerce	80	1	1

<tbody>
</tbody>

 

[Fluff]

Not sure why yo are looking at col A, try
=SUMPRODUCT(($B$2:$B$8=B2)*(C2<$C$2:$C$8))+1

 

[xlmaniac]

Not sure why yo are looking at col A, try
=SUMPRODUCT(($B$2:$B$8=B2)*(C2<$C$2:$C$8))+1

Dear Fluff,
Thanks for highlighting the error part.
Thanks also for helping me again with your support.
Really appreciate your help.

 

[Fluff]

You're welcome & thanks for the feedback