Here below is a data table:

To calculate the ranking (in descending order) by the sum of three columns Maths, English and PE, enter in cell F2:

=spl("=E(?1).(Maths+English+PE).rank@z(?2)",C$1:E$12,C2+D2+E2)

Drag F2 down to every relevant row:

esProc Desktop and Excel Processing
10.11 Ranking of row-based data - by combination of multiple columns
10.13 Concatenate members with the same ranking