Spreadsheet: 698615d1602078110-combining-countif-with-lookup-and-counting-averages-where-data-might-not-exist-golf-2020_version6_withoutswedishchars_witherrors
Sheet: 2020

Both 18 and 9 holes
Totals |  |  | Rounds: |  | Holes: |  |  | Gross score: |  |  |  | Net score: |  |  | Putts: |  | GIR: |  | FW: |  |  | Birdies:
Averages |  |  |  |  |  |  |  | Gross score avg. +/- par: |  |  |  | Net score avg. +/- par: |  |  | [NAME]. putts: |  | GIR %: |  | FW %:
Stats for 18 holes
Totals |  |  | Rounds |  | Holes |  | Score (R) |  |  |  |  | Putts |  | GIR % |  | FW %
Averages
Stats for 9 holes
Totals |  |  | Rounds |  | Holes |  | Score (R) |  |  |  |  | Putts |  | GIR % |  | FW %
Averages
Year | Month | Day | Course | Hcp | Shcp | Points | Course Par | Shots | Hole 1 | Hole 2 | Hole 3 | Hole 4 | Hole 5 | Hole 6 | Hole 7 | Hole 8 | Hole 9 | Hole 10 | Hole 11 | Hole 12 | Hole 13 | Hole 14 | Hole 15 | Hole 16 | Hole 17 | Hole 18 | Holes | GIR | GIR % | Penalties | BunkerShots | FW | FW Tot |  | [NAME] | Putts Total | PuttsHole 1 | PuttsHole 2 | PuttsHole 3 | PuttsHole 4 | PuttsHole 5 | PuttsHole 6 | PuttsHole 7 | PuttsHole 8 | PuttsHole 9 | PuttsHole 10 | PuttsHole 11 | PuttsHole 12 | PuttsHole 13 | PuttsHole 14 | PuttsHole 15 | PuttsHole 16 | PuttsHole 17 | PuttsHole 18
2020 | April | 10 | Bromma | 32.7 | 31 | 12 |  |  | 5 | 7 | 6 | 4 | 5 | 4 | 6 | 4 | 8
2020 | April | 11 | Bromma | 32.7 | 31 | 11 |  |  | 5 | 4 | 5 | 4 | 8 | 9 | 7 | 4 | 7
2020 | April | 16 | Bromma | 32.7 | 31 | 15 |  |  | 4 | 5 | 3 | 8 | 5 | 6 | 7 | 4 | 6
2020 | April | 19 | Hasselby | 32.7 | 30 | 15 |  |  | 5 | 6 | 6 | 6 | 6 | 6 | 5 | 3 | 5
2020 | April | 23 | Bromma | 32.7 | 31 | 12 |  |  | 6 | 7 | 6 | 4 | 4 | 8 | 4 | 4 | 6
2020 | April | 26 | Bromma | 32.7 | 31 | 13 |  |  | 5 | 5 | 4 | 8 | 4 | 6 | 8 | 3 | 8
2020 | May | 2 | Bromma | 32.7 | 31 | 12 |  |  | 6 | 5 | 5 | 5 | 8 | 5 | 5 | 4 | 9
2020 | May | 8 | Bromma | 32.7 | 31 | 13 |  |  | 3 | 5 | 4 | 8 | 6 | 7 | 5 | 5 | 7
2020 | May | 8 | Bromma | 32.7 | 31 | 13 |  |  | 5 | 5 | 6 | 8 | 4 | 5 | 5 | 5 | 7
2020 | May | 9 | Bromma | 32.7 | 31 | 14 |  |  | 4 | 4 | 4 | 5 | 8 | 6 | 6 | 5 | 6
2020 | May | 9 | Bromma | 32.7 | 31 | 15 |  |  | 4 | 7 | 3 | 3 | 4 | 6 | 6 | 5 | 9
2020 | May | 14 | Bromma | 32.7 | 31 | 14 |  |  | 5 | 4 | 5 | 4 | 5 | 7 | 7 | 4 | 6
2020 | May | 16 | Bromma | 32.7 | 31 | 20 |  |  | 4 | 7 | 4 | 4 | 2 | 6 | 8 | 4 | 3
2020 | May | 27 | Leksand |  |  | 23 |  |  | 7 | 7 | 8 | 7 | 4 | 8 | 6 | 8 | 8 | 5 | 5 | 6 | 9 | 7 | 7 | 5 | 7 | 8
2020 | June | 3 | Bromma |  |  | 21 |  |  | 5 | 3 | 5 | 5 | 4 | 4 | 5 | 8 | 4
2020 | June | 4 | Viksjo18 |  |  | 24 |  |  | 9 | 6 | 7 | 6 | 7 | 8 | 5 | 7 | 7 | 7 | 7 | 6 | 6 | 4 | 9 | 7 | 7 | 7 |  | Compares to KungsangenKings
2020 | June | 7 | Bromma |  |  | 19 |  |  | 4 | 4 | 5 | 3 | 3 | 7 | 6 | 3 | 8
2020 | June | 10 | Bromma |  |  | 10 |  |  | 7 | 8 | 8 | 4 | 3 | 9 | 6 | 2 | 9
2020 | June | 13 | Nacka |  |  | 32 |  |  | 5 | 9 | 9 | 7 | 6 | 4 | 8 | 3 | 5 | 7 | 6 | 7 | 7 | 4 | 7 | 8 | 9 | 4
2020 | June | 20 | Bromma |  |  | 16 |  |  | 5 | 5 | 4 | 5 | 5 | 6 | 5 | 3 | 9
2020 | June | 25 | Bromma |  |  | 12 |  |  | 5 | 5 | 6 | 5 | 3 | 6 | 7 | 5 | 8
2020 | July | 4 | Vaddo |  |  | 31 |  |  | 6 | 5 | 5 | 4 | 6 | 7 | 5 | 10 | 7 | 6 | 5 | 7 | 6 | 5 | 10 | 5 | 8 | 6 |  | Compares to Avesta
2020 | July | 6 | Tyreso |  |  | 38 |  |  | 7 | 9 | 5 | 7 | 5 | 5 | 5 | 4 | 5 | 4 | 6 | 9 | 4 | 5 | 4 | 4 | 4 | 6 |  | Compares to Avesta
2020 | July | 7 | Friiberghs |  |  | 33 |  |  | 8 | 5 | 7 | 5 | 9 | 4 | 7 | 7 | 4 | 7 | 7 | 9 | 4 | 5 | 5 | 6 | 5 | 7 |  | Compares to Bromma
2020 | July | 9 | [NAME] |  |  | 19 |  |  | 8 | 9 | 8 | 8 | 7 | 6 | 3 | 7 | 4 | 5 | 6 | 5 |  |  |  |  |  |  |  | Compares to [NAME]
2020 | July | 13 | Oregrunds |  |  | 41 |  |  | 4 | 7 | 10 | 6 | 10 | 6 | 5 | 7 | 5 | 6 | 3 | 6 | 5 | 3 | 6 | 8 | 6 | 5 |  | Compares to [NAME] - last course in CourseData
2020 | July | 16 | Ingaro |  |  | 33 |  |  | 6 | 6 | 4 | 7 | 8 | 8 | 9 | 6 | 5 | 6 | 7 | 4 | 7 | 3 | 6 | 9 | 4 | 5 |  | Compares to [NAME]
2020 | July | 19 | Vassunda |  |  | 34 |  |  | 6 | 5 | 6 | 6 | 6 | 8 | 5 | 7 | 6 | 8 | 6 | 5 | 7 | 7 | 7 | 4 | 6 | 9 |  | Compares to KungsangenKings
2020 | July | 21 | Bromma |  |  | 12 |  |  | 5 | 5 | 5 | 5 | 6 | 6 | 7 | 5 | 6
2020 | July | 23 | ArlandastadMasters |  |  | 37 |  |  | 6 | 6 | 9 | 5 | 4 | 5 | 6 | 6 | 8 | 6 | 8 | 6 | 5 | 6 | 7 | 5 | 7 | 6 |  | I don't understand why ArlandastadMasters doesn't compare at all?
2020 | July | 23 | Bromma |  |  | 17 |  |  | 6 | 5 | 3 | 3 | 8 | 4 | 6 | 4 | 9
2020 | July | 27 | Saltsjobadens |  |  | 29 |  |  | 6 | 8 | 5 | 7 | 7 | 8 | 8 | 3 | 6 | 5 | 6 | 5 | 10 | 3 | 8 | 7 | 7 | 7 |  | Compares to Nacka
2020 | July | 29 | ArlandastadMasters |  |  | 27 |  |  | 5 | 7 | 4 | 7 | 8 | 9 | 5 | 7 | 6 | 5 | 7 | 7 | 6 | 7 | 10 | 8 | 10 | 6 |  | I don't understand why ArlandastadMasters doesn't compare at all?
2020 | July | 31 | Taby |  |  | 37 |  |  | 8 | 6 | 6 | 4 | 5 | 7 | 4 | 6 | 4 | 6 | 9 | 10 | 6 | 4 | 6 | 8 | 8 | 6
2020 | August | 2 | Bromma |  |  | 20 |  |  | 4 | 6 | 3 | 3 | 5 | 6 | 5 | 4 | 6
2020 | August | 3 | Bromma |  |  | 25 |  |  | 4 | 4 | 5 | 3 | 2 | 4 | 7 | 4 | 4
2020 | August | 4 | Bromma |  |  | 19 |  |  | 5 | 5 | 4 | 3 | 7 | 5 | 4 | 4 | 6
2020 | August | 5 | Brollsta |  |  | 29 |  |  | 8 | 7 | 8 | 9 | 7 | 5 | 5 | 5 | 8 | 8 | 5 | 5 | 8 | 5 | 6 | 7 | 6 | 9 |  | I don't understand why Brollsta  doesn't compare at all?
2020 | August | 15 | Saters |  |  | 36 |  |  | 5 | 6 | 5 | 5 | 7 | 7 | 8 | 6 | 4 | 5 | 6 | 8 | 4 | 8 | 6 | 4 | 9 | 6 |  | Compares to Nacka
2020 | August | 16 | Avesta |  |  | 33 |  |  | 6 | 7 | 5 | 9 | 6 | 7 | 7 | 6 | 7 | 6 | 5 | 5 | 5 | 8 | 5 | 6 | 4 | 8 |  | I don't understand why [NAME]  doesn't compare at all?
2020 | August | 18 | Bromma |  |  | 15 |  |  | 4 | 8 | 3 | 3 | 5 | 7 | 7 | 8 | 4
2020 | August | 20 | Bromma |  |  | 11 |  |  | 3 | 7 | 6 | 8 | 4 | 5 | 6 | 5 | 9
2020 | August | 21 | Vallentuna |  |  | 30 |  |  | 5 | 7 | 5 | 7 | 6 | 8 | 6 | 7 | 6 | 4 | 6 | 4 | 5 | 9 | 4
2020 | August | 27 | Bromma |  |  | 22 |  |  | 6 | 3 | 4 | 3 | 5 | 5 | 4 | 4 | 5
2020 | August | 30 | Vallentuna |  |  | 33 |  |  | 6 | 7 | 3 | 9 | 6 | 4 | 7 | 7 | 5 | 6 | 7 | 6 | 5 | 6 | 4 | 9 | 5 | 5
2020 | September | 4 | Orbyhus |  |  | 42 |  |  | 5 | 10 | 5 | 5 | 7 | 5 | 3 | 6 | 6 | 6 | 9 | 6 | 4 | 8 | 7 | 4 | 5 | 7 |  | Compares to [NAME] - last course in CourseData
2020 | September | 5 | Hussborg |  |  | 30 |  |  | 6 | 4 | 6 | 7 | 5 | 5 | 5 | 9 | 7 | 9 | 5 | 8 | 6 | 9 | 4 | 7 | 6 | 5 |  | Compares to Bromma and can't find course in CourseData
2020 | September | 6 | Hussborg |  |  | 30 |  |  | 5 | 4 | 8 | 10 | 5 | 7 | 7 | 5 | 9 | 5 | 3 | 7 | 5 | 9 | 5 | 10 | 6 | 4 |  | Compares to Bromma and can't find course in CourseData
2020 | September | 11 | KungsangenKings |  |  | 34 |  |  | 8 | 5 | 6 | 6 | 8 | 9 | 3 | 7 | 6 | 9 | 4 | 5 | 5 | 7 | 5 | 6 | 5 | 8 |  | Compares to [NAME] and can't find course in CourseData
2020 | September | 13 | Viksjo9 |  |  | 21 |  |  | 6 | 6 | 4 | 4 | 5 | 3 | 4 | 4 | 4 |  |  |  |  |  |  |  |  |  |  | Can't find course in CourseData, but compares to the right course in CourseData
2020 | September | 17 | Bromma |  |  | 16 |  |  | 5 | 5 | 5 | 3 | 4 | 6 | 6 | 4 | 6
2020 | September | 21 | Drottningholms |  |  | 30 |  |  | 5 | 6 | 6 | 8 | 7 | 8 | 8 | 4 | 7 | 6 | 9 | 5 | 6 | 6 | 6 | 5 | 8 | 4 |  | Compares to Bromma and can't find course in CourseData
2020 | September | 23 | Bromma |  |  | 16 |  |  | 6 | 5 | 3 | 6 | 6 | 5 | 5 | 2 | 6
2020 | September | 26 | Nacka |  |  | 37 |  |  | 5 | 8 | 6 | 4 | 6 | 8 | 4 | 5 | 5 | 6 | 8 | 5 | 8 | 5 | 6 | 5 | 7 | 5
2020 | September | 27 | Viksjo9 |  |  | 17 |  |  | 3 | 9 | 9 | 4 | 9 | 4 | 2 | 5 | 2 |  |  |  |  |  |  |  |  |  |  | Can't find course in CourseData, but compares to the right course in CourseData
2020 | October | 3 | Viksjo9 |  |  | 15 |  |  | 4 | 9 | 7 | 4 | 9 | 4 | 4 | 3 | 4 |  |  |  |  |  |  |  |  |  |  | Can't find course in CourseData, but compares to the right course in CourseData
2020 | October | 4 | [NAME] |  |  | 33 |  |  | 4 | 7 | 3 | 5 | 4 | 7 | 7 | 6 | 6 | 3 | 9 | 7 | 5 | 6 | 5 | 4 | 6 | 3 |  | Compares to Leksand and can't find course in CourseData