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

1 | PLAYER | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total | Par 3 | Adjusted stableford points | Stroke Index |  |  | Handicap Alteration | New H'Cap
1 |  | PAR | 4 | 4 | 5 | 3 | 3 | 4 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 5 | 4 |  |  |  | Playing H'Cap
1 |  | S/I | 18 | 4 | 12 | 14 | 10 | 16 | 2 | 8 | 6 | 11 | 1 | 7 | 3 | 13 | 15 | 17 | 5 | 9 | 69 |  |  | S/I 1 | S/I 2 | S/I 3
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
1 | [NAME] |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 5 | 6 | 7
1 | [NAME] |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 6 | 6 | 6 | 6 | 6 | 4 | 6 | 6 | 6 | 6 | 4
1 | [NAME] |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 6 | 5 | 6 | 5 | 6 | 5 | 6 | 5 | 6 | 5
1 | [NAME] |  | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 4
1 | [NAME] |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
1 | [NAME] |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
1 | [NAME] |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 6 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
1 | [NAME] |  | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 6 | 7 | 8
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
 |  | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total
 |  | PAR | 4 | 4 | 5 | 3 | 3 | 4 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 5 | 4
 |  | S/I | 14 | 2 | 8 | 16 | 18 | 12 | 6 | 4 | 10 | 15 | 3 | 9 | 1 | 17 | 11 | 7 | 5 | 13 | 71
 | Number of Players
 | Average Score
 | PARS
 | BIRDIES
 | Total Score