Excel problem

Solved/Closed
ptkdave Posts 6 Registration date Wednesday February 8, 2012 Status Member Last seen February 9, 2012 - Feb 9, 2012 at 04:52 AM
ptkdave Posts 6 Registration date Wednesday February 8, 2012 Status Member Last seen February 9, 2012 - Feb 9, 2012 at 05:58 PM
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

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Feb 9, 2012 at 10:19 AM
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
0
ptkdave Posts 6 Registration date Wednesday February 8, 2012 Status Member Last seen February 9, 2012
Feb 9, 2012 at 05:58 PM
Thanks for help.

Dave
0