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
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
461
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!