Student ranking based on pass or fail and average grade (multiple condition)

Hi,

I am in progress to build offline exam marksheet for school. I want to rank students based on first, considering PASS or FAIL, then looking at average grade.
Group of Pass student will be on upper ranking then group of Fail student will be lower ranking. Then,for average grade, the minimum value will be upper ranking.

Desire output:-

RANK.png

Current formula:-
=IF(AK13="PASS",SUMPRODUCT(--(AK13=$AK$13:$AK$53),--(AJ13<=$AJ$13:$AJ$53)))+IF(AK13="FAIL",SUMPRODUCT(--(AK13=$AK$13:$AK$53),--(AJ13<=$AJ$13:$AJ$53)))

Problems:-

1. When I use the above formula, the output will be divided by group of Pass and Fail students but the problem is for the Fail student it will started with 1 again which is not continuous from previous list.
2. Then, when we want to setup the formula to other cells, it becomes error for the entire columns.
3. Let's say, Grade 1 have 3 classes, how do I rank students together between other class?
   

Here, together I attached the workbook.
I hope members willing to help me to solve these problems please. Thanks a lot

Thanks to Naveed and nflsales for your feedback and help.
I've try your suggestion but I still need a solution for ranking.

Naveed suggestion to use same formula for AL column.
1.png

nflsales suggestion formula for AL column.
2.png

Hopes your help and kindness

Originally Posted by samba_ravi

see attached file

I have a same problem with this... Please sent me the attachment file if you permit