How to select the top "values" in each row of the spreadsheet

[bobarags]

I teach a math class and when I give 8 quizzes, I drop the two or three lowest grades for each student. How can I accomplish this in Libreoffice Spreadsheet?

[mahfiaz]

It depends how you need your data next. But let’s assume you want just a sum of the points minus 2 lowest:

=SUM(A1:A9)-SMALL(A1:A9;1)-SMALL(A1:A9;2)

or maybe you need the average:

=(SUM(A1:A9)-SMALL(A1:A9;1)-SMALL(A1:A9;2))/(COUNT(A1:A9)-2)

Or you might find =QUARTILE(A1:A9;1) an interesting function

[qubit1]

@bobarags – did this Answer help you out?