Formula help
 

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.


--
flipflop1970
------------------------------------------------------------------------
flipflop1970's Profile: http://www.excelforum.com/member.php...o&userid=33463
View this thread: http://www.excelforum.com/showthread...hreadid=532663

Formula help
 

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

Hope this helps.

Pete

Formula help
 

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

=IF(A1LARGE(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" wrote:


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.


--
flipflop1970
------------------------------------------------------------------------
flipflop1970's Profile: http://www.excelforum.com/member.php...o&userid=33463
View this thread: http://www.excelforum.com/showthread...hreadid=532663

Formula help
 

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

Thanks this worked great!!!!


--
flipflop1970
------------------------------------------------------------------------
flipflop1970's Profile: http://www.excelforum.com/member.php...o&userid=33463
View this thread: http://www.excelforum.com/showthread...hreadid=532663