Trying to sum a range and drop the lowest 2 scores

[Leatherfoot]

Hi Guys, I hope you can help me out...

I'm currently keeping stats for an online racing league and I need t
have a range of cells summed but I need to be able to ignore the lowes
2 scores.

The file is setup so that each race has it's own sheet and each driver
point for the races is in the same cell on each sheet. For exampl
Driver 'A' has cell E9 on all sheets, Driver 'B' has E10 etc.

Currently I just sum down the sheets to get the total points (there ar
two hidden sheets called 'start' and 'end' so I sum from start to en
which allows me to add sheets in between as more races occur) But ou
league drops the worst two (to allow for disconnects or bad days etc.
I need to be able to get this file to do that.

To make it more complicated, there are other stats that are calculate
(summed) as well like Owners Points, Damage Cost, etc that need to b
dropped as well based on the on the criteria above (driver points) s
all the stats from those dropped races don't count.

Does that make sense?

Here is one of the files in case someone wants to take a look at i
since it's kinda hard to explain. It's the 'points' column that need
to be queried. http://www.bingo1.ca/GNS_Results_test.zip

Also, if someone can explain why the file is 22MB unzipped it would b
appreciated as well... lo

 

[Frank Kabel]

Hi
try something like
=SUM('start:end'!E9)-MIN('start:end'!E9)-SMALL('start:end'!E9,2)
for your first question