Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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



See more

2 replies

Answer 1 / 2
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
Answer 2 / 2
Posts
6
Registration date
Wednesday February 8, 2012
Status
Member
Last seen
February 9, 2012
Thanks for help.

Dave
Ask a question