Thanks Don,
Works great, but what if one of my cells has text "DNF", value is zero. but
when i use the above forumla it give me a #num error. Thanks

"Don Guillett" wrote:

=SUM(LARGE(A27:J27,{1,2,3,4,5,6}))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"okracerx" wrote in message
...
I need to be able to calculate the sum of, "the best of 6". Here is an
example:

Andy Harris 60 54 48 38 60 60 60 22 34

Total is 342

Would like a formula that would figure this out for me.

Thanks

.