Here below is a data table:

Sort in reverse order by the sum of three columns, Maths, English and PE:

=spl("=E(?).sort(Maths+English+PE:-1)",A1:E12)

esProc Desktop and Excel Processing
10.3 Sorting of row-based data - by combination of multiple columns
10.5 Sort in group