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
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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