How to find and sum top n from each columns?

  • Thread starter Thread starter Sunny
  • Start date Start date
S

Sunny

I have score of each game (12 games) for each player. I need to sum only top
10 (best 10) from each player how can I do it?
e.g

Game# Player1 Player2 Player3 Player4
1 85 97 99 91
2 102 90 110 95
3 72 95 112 93
4 90 93 105 99



Total 192 192 222 194
(top 2 games)


Hope it makes clear.

Thanks.
 
Sunny,

For Player 1

=SUM(LARGE(B1:B20,{1,2,3,4,5,6,7,8,9,10}))

etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Assuming your data starts in row 3 and finishes row 14 for each player, then the
following formula will give you the data you need for the player in Col A

=SUMPRODUCT(LARGE($A$3:$A$14,ROW(INDIRECT("1:10"))))

You can use the same to do your top 2 as well, or even just

=SUMPRODUCT(LARGE($A$3:$A$14,{1,2}))
 
I have score of each game (12 games) for each player. I need to sum only top
10 (best 10) from each player how can I do it?
e.g

Game# Player1 Player2 Player3 Player4
1 85 97 99 91
2 102 90 110 95
3 72 95 112 93
4 90 93 105 99



Total 192 192 222 194
(top 2 games)


Hope it makes clear.

Thanks.
Click to expand...

=SUM(LARGE(rng,{1,2,3,4,5,6,7,8,9,10}))


--ron
 
-----Original Message-----
I have score of each game (12 games) for each player. I need to sum only top
10 (best 10) from each player how can I do it?
e.g

Game# Player1 Player2 Player3 Player4
1 85 97 99 91
2 102 90 110 95
3 72 95 112 93
4 90 93 105 99
Click to expand...
Hi Sunny,

Not sure if this is what you are looking for, but give
this a try. Go to top and click on Data then Filter then
Auto-Filter. You should see little drop down arrows
appear at top of each column. Click on drop down box -
one of your first filter options should be Top Ten.
Select this and it should return just the top 10 scores.

Hope that helps. Good Luck. Brian
 
Back
Top