Excel problem [Solved/Closed]

Report
Posts
6
Registration date
Wednesday February 8, 2012
Status
Member
Last seen
February 9, 2012
-
Posts
6
Registration date
Wednesday February 8, 2012
Status
Member
Last seen
February 9, 2012
-
Hello,

Hello,
I am hoping that someone can help with the following problem,

I have a list of numbers, golf staplford scores, located in cells D-AN, these random numbers are loaded weekly and what I am trying to do is, in say cell AP, at the end of season, have each member's top 6 scores totaled.
Thanks in advance for any suggestions.

David



2 replies

Posts
2657
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 22, 2020
440
Hi David,

Assuming that each member has it's own row, try this formula:
=SUM(LARGE(D2:AN2;1)+LARGE(D2:AN2;2)+LARGE(D2:AN2;3)+LARGE(D2:AN2;4)+LARGE(D2:AN2;5)+LARGE(D2:AN2;6))

Best regards,
Trowa
Posts
6
Registration date
Wednesday February 8, 2012
Status
Member
Last seen
February 9, 2012

Thanks for help.

Dave