10.12 Ranking of row-based data - by expression

 

Here below is a data table:

imagepng

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)

imagepng

Drag F2 down to every relevant row:

imagepng