Trying to sum a range and drop the lowest 2 scores
 

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

--
Message posted from http://www.ExcelForum.com

Trying to sum a range and drop the lowest 2 scores
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

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

The file is setup so that each race has it's own sheet and each
drivers point for the races is in the same cell on each sheet. For
example 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
are two hidden sheets called 'start' and 'end' so I sum from start to
end which allows me to add sheets in between as more races occur) But
our 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
calculated
(summed) as well like Owners Points, Damage Cost, etc that need to be
dropped as well based on the on the criteria above (driver points) so
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 it
since it's kinda hard to explain. It's the 'points' column that needs
to be queried. http://www.bingo1.ca/GNS_Results_test.zip

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


---
Message posted from http://www.ExcelForum.com/