I am doing a Pool in which the contestant picks 10 golfers. We "throw" out
the five highest scores, resulting in the lowest five scores counting. I
have an example below using very small numbers for simplicity.

Row G10 H10:Y10
1 5 3 8 5 10 7 2 9 4 6 Result in Z10 should be
15 (1,2,3,4,5)

I'm trying to learn Excel (I'm 75 years old), but this formula is beyond my
knowledge.

Although not necessary, is it possible to highlight in color the lowest five
scores through Conditional Formatting?

Bob M.