Spreadsheet: 819299d1677399651-formula-to-check-if-same-value-then-do-calculation-example2
Sheet: Sheet1

 | SELECTIONS |  |  |  |  |  | MR RESULT |  |  |  |  | 1 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 4 |  |  |  |  |  | 5 |  |  |  |  | 6 |  |  |  |  | 7 |  |  |  |  | 8 |  |  |  |  | 9 |  |  | SR RESULT
RACES | MR | MR | MR | SR | SR | SR | 1st | 2nd | 3rd | 4th | PNT | A1 | & | A2 | PNT | PNT | B1 | & | B2 | PNT | PNT | C1 | & | C2 | PNT |  |  | & |  |  |  |  | & |  |  |  |  | & |  |  |  |  | & |  |  |  |  | & |  |  |  |  | & |  |  | 1st | 2nd | 3rd | 4th
R1 | XX | XX | XX | XX | XX | XX | 1 | 5 | 3 | 6 | 0 |  | R1 |  | 0 | 0 |  | R1 |  | 0 | 0 |  | R1 |  | 0 |  |  | R1 |  |  |  |  | R1 |  |  |  |  | R1 |  |  |  |  | R1 |  |  |  |  | R1 |  |  |  |  | R1 |  |  | 9 | 2 | 14 | 5
R2 | 8 | 1 | 2 | XX | XX | XX | 2 | 8 | 10 | 3 | 3 |  | R2 |  | 0 | 0 |  | R2 |  | 0 | 5 |  | R2 |  | 0 |  |  | R2 |  |  |  |  | R2 |  |  |  |  | R2 |  |  |  |  | R2 |  |  |  |  | R2 |  |  |  |  | R2 |  |  | 5 | 7 | 10 | 9
R3 | 4 | 2 | 1 | 3 | 5 | 1 | 4 | 2 | 9 | 6 | 5 |  | R3 |  | 5 | 3 |  | R3 |  | 1 | 0 |  | R3 |  | 3 |  |  | R3 |  |  |  |  | R3 |  |  |  |  | R3 |  |  |  |  | R3 |  |  |  |  | R3 |  |  |  |  | R3 |  |  | 3 | 1 | 9 | 5
R4 | 4 | 10 | 9 | 5 | 3 | 6 | 4 | 6 | 5 | 7 | 5 |  | R4 |  | 1 | 0 |  | R4 |  | 2 | 0 |  | R4 |  | 0 |  |  | R4 |  |  |  |  | R4 |  |  |  |  | R4 |  |  |  |  | R4 |  |  |  |  | R4 |  |  |  |  | R4 |  |  | 2 | 7 | 3 | 4
R5 | 7 | 6 | 1 | 14 | 1 | 11 | 6 | 1 | 8 | 7 | 1 |  | R5 |  | 0 | 5 |  | R5 |  | 0 | 3 |  | R5 |  | 2 |  |  | R5 |  |  |  |  | R5 |  |  |  |  | R5 |  |  |  |  | R5 |  |  |  |  | R5 |  |  |  |  | R5 |  |  | 8 | 5 | 11 | 9
R6 | 1 | 4 | 8 | 11 | 6 | 1 | 8 | 4 | 1 | 9 | 2 |  | R6 |  | 5 | 3 |  | R6 |  | 1 | 5 |  | R6 |  | 0 |  |  | R6 |  |  |  |  | R6 |  |  |  |  | R6 |  |  |  |  | R6 |  |  |  |  | R6 |  |  |  |  | R6 |  |  | 11 | 2 | 10 | 6
R7 | 13 | 4 | 6 | 2 | 14 | 1 | 2 | 4 | 14 | 6 | 0 |  | R7 |  | 1 | 3 |  | R7 |  | 3 | 1 |  | R7 |  | 5 |  |  | R7 |  |  |  |  | R7 |  |  |  |  | R7 |  |  |  |  | R7 |  |  |  |  | R7 |  |  |  |  | R7 |  |  | 1 | 14 | 3 | 2
R8 | 2 | 10 | 11 | 11 | 13 | 5 | 13 | 12 | 10 | 2 | 1 |  | R8 |  | 3 | 2 |  | R8 |  | 0 | 0 |  | R8 |  | 1 |  |  | R8 |  |  |  |  | R8 |  |  |  |  | R8 |  |  |  |  | R8 |  |  |  |  | R8 |  |  |  |  | R8 |  |  | 1 | 11 | 10 | 5
R9 | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | 0 |  | R9 |  | 0 | 0 |  | R9 |  | 0 | 0 |  | R9 |  | 0 | 0 |  | R9 |  |  |  |  | R9 |  |  |  |  | R9 |  |  | 0 |  | R9 |  |  |  |  | R9 |  |  |  |  | R9 |  |  | XX | XX | XX | XX
R10 | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | 0 |  | R10 |  | 0 | 0 |  | R10 |  | 0 | 0 |  | R10 |  | 0 | 0 |  | R10 |  |  |  |  | R10 |  |  |  |  | R10 |  |  | 0 |  | R10 |  |  |  |  | R10 |  |  |  |  | R10 |  |  | XX | XX | XX | XX
 | MR | VENUES
 | SR | VENUES
 | XX | NOT INCLUDED TODAY |  |  |  |  |  |  |  |  | PNT | POINTS MADE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #4 ONWARDS ARE ALLSELECTIONS MADE FROM 1 2 &3IN A SYSTEM
 |  |  |  |  |  |  |  |  |  |  | POINT SYSTEM IS
 |  |  |  |  |  |  |  |  |  |  | 1ST | 5
 |  |  |  |  |  |  |  |  |  |  | 2ND | 3 |  |  |  |  |  |  |  |  |  |  |  |  | IS IT POSSIBLE TO MAKE A FORMULA TO ENABLE THE POINTS (IN RED) TO BE INSERTED AUTOMATICALLY ONCE THE RESULTS (IN BLUE) OF 1ST, 2ND, 3RD, AND 4TH ARE ENTERED?
 |  |  |  |  |  |  |  |  |  |  | 3RD | 2
 |  |  |  |  |  |  |  |  |  |  | 4TH | 1
 |  |  |  |  |  |  |  |  |  |  | A1, A2, B1,B2,C1,C2
 |  |  |  |  |  |  |  |  |  |  | ABOVE ARE THE SELECTIONS MADE FOR EACH RACE
 |  |  |  |  |  |  |  |  |  |  | R1-R10
 |  |  |  |  |  |  |  |  |  |  | THESE ARE RECE NUMBERS