Excel Ranking with multiple criteria support

[Hyperion1571]

Hello all,
I'm trying to set up a ranking that will give the top 3 from highest Total results.
Not sure on the issue but it randomly skips rankings

It should be if 100% pass then the ranking is based of the total, if not 100% the its not taken into consideration.
I have attached a demo doc for view and to help if possible.

Thanks in advance