Spreadsheet: 679346d1590342694-combining-countif-with-lookup-and-counting-averages-where-data-might-not-exist-golf-2020_draft_version2
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(D14="","",COUNTIFS(INDEX(CourseData!$E$2:$V$20,MATCH(D14,CourseData!$A$2:$A$20,),),">3",J14:AA14,">0"))
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 | [NAME] | Holes | GIR | GIR % | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
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 | Hässelby | 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 | maj | 2 | Bromma | 32.7 | 31 | 12 |  |  | 6 | 5 | 5 | 5 | 8 | 5 | 5 | 4 | 9
2020 | maj | 8 | Bromma | 32.7 | 31 | 13 |  |  | 3 | 5 | 4 | 8 | 6 | 7 | 5 | 5 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 2
2020 | maj | 8 | Bromma | 32.7 | 31 | 13 |  |  | 5 | 5 | 6 | 8 | 4 | 5 | 5 | 5 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2
2020 | maj | 9 | Bromma | 32.7 | 31 | 14 |  |  | 4 | 4 | 4 | 5 | 8 | 6 | 6 | 5 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 1 | 1 | 4 | 1 | 2 | 2 | 1
2020 | maj | 9 | Bromma | 32.7 | 31 | 15 |  |  | 4 | 7 | 3 | 3 | 4 | 6 | 6 | 5 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 2 | 1 | 1 | 3 | 2 | 2 | 2
2020 | maj | 14 | Bromma | 32.7 | 31 | 14 |  |  | 5 | 4 | 5 | 4 | 5 | 7 | 7 | 4 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 1 | 3 | 2 | 1 | 1 | 2
2020 | maj | 16 | Bromma | 32.7 | 31 | 20 |  |  | 4 | 7 | 4 | 4 | 2 | 6 | 8 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 1 |  |  |  |  | 1 | 2 | 1 | 1 | 1 | 2 | 2 | 2 | 1
2020 | maj | 20 | Nacka | 32.7 | 35 | 23 |  |  | 6 | 7 | 7 | 8 | 7 | 2 | 4 | 8 | 6 | 4 | 7 |  |  |  |  |  |  |  |  |  | 4 |  | 6
2020 | maj | 21 | Nacka | 32.7 | 35 | 34 |  |  | 6 | 7 | 7 | 8 | 7 | 3 | 5 | 8 | 6 | 4 | 7 | 4 | 5 | 6 | 5 | 7 | 8 | 8 |  |  | 5 |  | 12
 |  |  | Bromma |  |  |  |  |  | 3 | 4 | 5 | 6 | 2 | 3 | 4 | 5 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1