Culling low columns

[patenglish]

Hi,
I am a member of a local Bass club and we post the results of each 11
tournaments on a spreadsheet. The three lowest tournaments are culled
from the total. I need a formula that will subtract the three lowest
totals from each member. The rows are set up as follows:
Member Name, Tournament 1 points, Tournamnet 2 points, Tournament 3
points, Tournament 4 points, etc until tournament 11, and the last
column is the total points for the tournaments.
The next row has the next member.........
Hope that I have given enough information...If not please advise...

 

[BenjieLop]

Hi,
I am a member of a local Bass club and we post the results of each 11
tournaments on a spreadsheet. The three lowest tournaments are culled
from the total. I need a formula that will subtract the three lowest
totals from each member. The rows are set up as follows:
Member Name, Tournament 1 points, Tournamnet 2 points, Tournament 3
points, Tournament 4 points, etc until tournament 11, and the last
column is the total points for the tournaments.
The next row has the next member.........
Hope that I have given enough information...If not please advise...

This could be the formula that you need:

=SUM(B2:L2)-SUM(SMALL(B2:L2,{1,2,3}))

where B2:L2 -- points from Tournament 1 to Tournament 11.

Copy this formula down until your range requirement is met.

Regards.

 

[Biff]

Hi!

Assume A1:M1 are the column headers:

Member Name, Tournament 1 points, Tournamnet 2 points, Tournament 3
points, Tournament 4 points, etc until tournament 11, Total Points

Enter this formula in M2:

=SUM(B2:L2,-SUM(SMALL(B2:L2,{1,2,3})))

Copy down as needed.

Biff

 

[Ragdyer]

One less function call<g>:

=SUM(B2:L2,-SMALL(B2:L2,{1,2,3}))