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