Spreadsheet: 749323d1632731361-simple-formula-giving-incorrect-result-midshires-master-2022
Sheet: Results

INDIVIDUAL |  |  |  |  |  |  |  | TEAM
PLAYER | PAR 3 | TOTAL | S/I 1 | S/I 2 | S/I 3 | No |  | PLAYER | PLAYER | PLAYER | PLAYER | TOTAL | S/I 1 | S/I 2 | S/I 3 | S/I 4 | S/I 5 |  |  |  |  | No | PLAYER | PAR 3 | TOTAL | s/index 1 | s/index 2 | s/index 3 | PLAYING |  |  |  | No | PLAYER | PLAYER | PLAYER | PLAYER | TOTAL | S/I 1 | S/I 2 | S/1/3 | S/1/4 | S/1/5
 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  | 11 |  | SKINS |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  | 12 |  | POT | 60 |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  | par 3 | Order of Merit | Position | Rank
 |  |  |  |  |  | 13 |  | HOLE |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 14 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 15 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 16 |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 17 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 18 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 19 |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 20 |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 21 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 22 |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 23 |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 24 |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 25 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 26 |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 27 |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 28 |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 29 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 30 |  | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 31 |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 64 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  | 65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  | 66 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  | 67 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  | 68 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70