Race points

Hi guys I have another one....I had a formula that worked but we have changed it a little and now the set up doesnt work with my forumla.

Racers attend 7 races and their total points is based on the best 5 out of 7 plus bonus points.

My old spreadsheet had the TOTAL points for each race. This new one has the breakdown of the points...

This is my old formula =SUMPRODUCT(--(LARGE(C3:I3,{1,2,3,4,5})))+(J3+K3+L3)

J3, K3 and L3 use to be my bonus points now its just one cell.

Here is the spreadsheet

Ok the way that it needs to work is that the total points should be the best 5 out of 7 event + the bonus point colum so the total in Z3 for racer 1 should include
The totals from Race 1, Race 2, Race 3, Race 4, Race 5 and the bonus points so his final total would be 2730.
I need the total for each race which includes Q,E and S.

Make sense?

Originally Posted by donkeyote

perhaps then:

Please Login or Register  to view this content.

perfect!!!

Thank you =)

I need some help editing this spreadsheet again.

The first formula works fabulous.

I just need two more.

The formula in the season total colum already takes away a racers WORST (or lowest points) races. I just need that amount of the WORST races to show up in the Dropped Races Column.

The other thing I need is a formula for the bonus point column.
Basically the way it works is like this...if you attend 5 races you get 25 points if you attend 6 you get an additional 50 and if you attend all 7 you get an additional 100 for a total of 175. Is there a way to write a formula that says if you get points in the "S" column under the races that it will count them and add that number in autmatically? So say for racer 1 he should have 75 points already in the bonus field and once I add in points for race 7 in should change to 175.
Does that make sense?

Ok you guys were soooo much help with this already I need some additional help. I tried to modify the formulas myself but I just jacked them up! I am an accountant.....we just do subtraction and addition!!!

Column V-Bonus I need it to calculate bonus points based on attendance for 4 its 25 points for 5 its 75 or for 6 its 125 these are totals. So I need it to recognize ATTENDANCE by the values in the columns titles with an (S)

Column W this is the formula I had from above Z3:
=SUM(LARGE(SUBTOTAL(9,OFFSET($D3:$F3,0,{0,3,6,9,12,15,18})),{1,2,3,4,5}),Y3)
copied down

But I need it to calulate the best 4 out of 6 races now. I know its probably a simple solution to change it but like I said I kept messing it up. Any help would be appreciated.

Here is an example of the spreadsheet

Originally Posted by arlu1201

shanshine,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

I was the original poster......the help I need is for a modification to the formulas already given to me.