Formula help

F

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.
 
P

Pete_UK

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

Hope this helps.

Pete
 
C

CLR

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
 
Top