Dropping Lowest Grade

Attached doc show the two formula solutions from my previous post applied to your gradebook.
The appropriate totals are in the yellow A22:B22.
The RATs formula refers to these cells.
Conditional formatting adds grey background to the column C cells with the RAT test names to make it easy to identify the omitted tests.
Tie breaking had to be used in the second sheet formulas so that the test names could be identified.
Helper columns are hidden.