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


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1656205971138
https://c.scudata.com/article/1656298205915