Adding up scores

[Sheepkin_Coat]

I have a spreadsheet with formula one drivers names on and i want to be able to put the position of the driver from the race in and it puts the points in a cell for me.

gp.xlsx

on the spreadsheet if you enter 1 to 26 you get a different colour, also if you put DNQ, DNS, RET DSQ.

What i want to be able to do is if i put the number 1 and a cell under race 1 i want it to add the 10 points

and so on like this

2nd 6
3rd 4
4th 3
5th 2
6th 1

and then when i put the second places under race two it will add up the scores if there are any.

Can this be done

Thanks

[AL1976]

I think it works by entering in T4 the following formula

=IF(D4=1;10;IF(D4=2;6;IF(D4=3;4;IF(D4=4;3;IF(D4=5;2;IF(D4=6;1;0))))))+IF(E4=1;10;IF(E4=2;6;IF(E4=3;4;IF(E4=4;3;IF(E4=5;2;IF(E4=6;1;0))))))+IF(F4=1;10;IF(F4=2;6;IF(F4=3;4;IF(F4=4;3;IF(F4=5;2;IF(F4=6;1;0))))))+IF(G4=1;10;IF(G4=2;6;IF(G4=3;4;IF(G4=4;3;IF(G4=5;2;IF(G4=6;1;0))))))+IF(H4=1;10;IF(H4=2;6;IF(H4=3;4;IF(H4=4;3;IF(H4=5;2;IF(H4=6;1;0))))))+IF(I4=1;10;IF(I4=2;6;IF(I4=3;4;IF(I4=4;3;IF(I4=5;2;IF(I4=6;1;0))))))+IF(J4=1;10;IF(J4=2;6;IF(J4=3;4;IF(J4=4;3;IF(J4=5;2;IF(J4=6;1;0))))))+IF(K4=1;10;IF(K4=2;6;IF(K4=3;4;IF(K4=4;3;IF(K4=5;2;IF(K4=6;1;0))))))+IF(L4=1;10;IF(L4=2;6;IF(L4=3;4;IF(L4=4;3;IF(L4=5;2;IF(L4=6;1;0))))))+IF(M4=1;10;IF(M4=2;6;IF(M4=3;4;IF(M4=4;3;IF(M4=5;2;IF(M4=6;1;0))))))+IF(N4=1;10;IF(N4=2;6;IF(N4=3;4;IF(N4=4;3;IF(N4=5;2;IF(N4=6;1;0))))))+IF(O4=1;10;IF(O4=2;6;IF(O4=3;4;IF(O4=4;3;IF(O4=5;2;IF(O4=6;1;0))))))+IF(P4=1;10;IF(P4=2;6;IF(P4=3;4;IF(P4=4;3;IF(P4=5;2;IF(P4=6;1;0))))))+IF(Q4=1;10;IF(Q4=2;6;IF(Q4=3;4;IF(Q4=4;3;IF(Q4=5;2;IF(Q4=6;1;0))))))+IF(R4=1;10;IF(R4=2;6;IF(R4=3;4;IF(R4=4;3;IF(R4=5;2;IF(R4=6;1;0))))))+IF(S4=1;10;IF(S4=2;6;IF(S4=3;4;IF(S4=4;3;IF(S4=5;2;IF(S4=6;1;0))))))

[DBY]

Hello
Perhaps using Sumproduct would be easier, for example in T4 copied down:

Please Login or Register  to view this content.

Here the point and position arrays are hard coded but they could be placed on the spreadsheet and referenced there for ease of editing, for example:

Please Login or Register  to view this content.

Here they are in the range W5:X10.

DBY

[newdoverman]

Here is one way of solving the problem.

[AL1976]

regarding the solution I suggested earlier today (I live in Italy and wrote the formula as it works on my computer), I think that in the UK or US, in formulas, ";" must be replaced by ",".
hope that this will help.

[AL1976]

Here is the file showing the solution I proposed.

gp.xlsx

[Sheepkin_Coat]

Here is the file showing the solution I proposed.

Attachment 292273

Thanks i will use that for my spreadsheet, it work great

[AL1976]

:-) :-) :-)