Ranking in categories

In MD column N3 and drag down

=SUMPRODUCT((C3=$C$3:$C$14)*(K3<$K$3:$K$14))+1

In RD column O3 and drag down

=SUMPRODUCT((D3=$D$3:$D$14)*(K3<$K$3:$K$14))+1

...and (edit) just for completeness

In total company column M3 and drag down

=RANK(K3,$K$3:$K$14,0)