=SUM(C25:C32)-MAX(C25:C32)-MIN(C25:C32)

Change it to suit your needs
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"SmartCookie" wrote:

Hello,

I'm trying to help a friend who is keeping scores for races. He wants
to drop the lowest and highest scores and sum the rest. This would be
a worksheet with about 15 rows (names) and 10 columns of numbers (10
race scores). Not too big. I'm sure I could do some complicated
nesting function, but is there something more simple?

Thanks!
Michelle Boggs