10.4 Sorting of row-based data - by expression

 

Here below is a data table:

imagepng

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

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

imagepng