Determine LARGE with most recent data point excluded

Hello All,

First post here but have been a long-time lurker. I have an interesting Excel issue that has me stumped and I'm hoping you fine folks might be able to come up with a solution. I will throw down the gauntlet and say that I'm very proficient at Excel and typically am offering help to others but this one has me scratching my head. If you can solve this, you are definitely a worthy Excel user!!!

Here is my data as laid out in the spreadsheet

Col_A_____Col_B______Col_C_______Col_D_______Col_E______Col_F
Most Recent Event Date: 06/01/10
01/1/10____02/1/10____03/1/10______04/1/10_____05/01/10____06/01/10
355_______420________405_________257_________330________415

I am using the following formula to summate the top 4 of 6 available values currently:
=SUM(LARGE(($A2,$B2,$C2,$D2,$E2,$F2),{1,2,3,4}))

What I need to do is find the sum of the largest 4 values and exclude the value that matches the "Most Recent Event Date" of 06/01/10. The Most Recent Event Date will of course change as new data events are added with new dates, so if a match occurs between the Most Recent Event Date and the column Event Date, then that data entry should not be included in the LARGE function.

My use for the spreadsheet is to enter monthly data after is occurs (think sports scoring), and want to determine the total score amongst all participants prior to the last sporting event (thus the reason for excluding the last Event Date). This will allow me to calculate a historical ranking and then compare the historical rank to the most recent rank to see which competitors increased or decreased in rank after the newest scores are posted.

I told you this was a doozy. I would appreciate any help you folks can provide. Feel free to reply with any questions and I would be happy to further clarify and troubleshoot.