Thread: 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:

z3:
=sum(large(subtotal(9,offset($d3:$f3,0,{0,3,6,9,12,15,18})),{1,2,3,4,5}),y3)
copied down

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?