Jun 03,2008, 10:24 PM
|
#19 |
| #bonking
Join Date: Nov 2004 Location: South Bay, California
Posts: 5,920
| Quote:
Originally Posted by moose The following formula will return the sum of the top 3 values in a list
=SUM(LARGE(B1:B100,{1,2,3})) Vertical Column
More likely you would make a spreadsheet where the LH column is the list of players names, with the points earned per tourney horizontally in a row.
=SUM(LARGE(B1:Z1,{1,2,3})) Horizontal row
you can add 4,5,6 - however many tourneys you want to count in the row | uh...this??
__________________
That level 5 trap really paid off...ship him the cookies.
|
| |