Formula help

[flipflop1970]

I have poker league and I use excel to keep track of points each week.

There are 20 weeks in the league but I only want to be able to use each
persons top 10 point totals. How woould I go about using a formula
that would only add the ten highest point totals.

 

[Pete_UK]

You could use a RANK( ) formula on the points and then SUMIF( ) looking
at ranks below 11.

Hope this helps.

Pete

 

[Guest]

In a helper column, put this and copy down.........

=IF(A1>LARGE(A:A,11),A1,"")

Then, sum the helper columnn

or, use this........
=SUM(LARGE(A:A,{1,2,3,4,5,6,7,8,9,10}))

hth
Vaya con Dios,
Chuck, CABGx3

 

[flipflop1970]

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

Thanks this worked great!!!!