[idkfa]

Sum them all and then subtract from that the lowest 2 using the SMALL function. A1:F1 is the range of the scores and -SMALL(A1:F1,1) subtracts the smallest and -SMALL(A1:F1,2) subtracts the next smallest.

=SUM(A1:F1)-SMALL(A1:F1,1)-SMALL(A1:F1,2)

[econprof]

I don't know the SMALL function. That looks simpler than what I would have done.

I would have used the MIN function to find the lowest score. Then I would find the second lowest by taking the MAX of the 6 values which are the minimums of all but the first, second, third, fourth, fifth, and six scores.

[Fan of Fiat]

Very nice. I've never used the small function.

[Tanniker Smith]

Sum them all and then subtract from that the lowest 2 using the SMALL function. A1:F1 is the range of the scores and -SMALL(A1:F1,1) subtracts the smallest and -SMALL(A1:F1,2) subtracts the next smallest. =SUM(A1:F1)-SMALL(A1:F1,1)-SMALL(A1:F1,2)

DING! DING! DING!! We have a winner!

Thank you. I didn't know about the SMALL function. That's exactly what I needed. I'll give it a try.