Spreadsheet: 736373d1623570932-reducing-a-long-countif-formula-excel-help
Sheet: 21-22 Cold Ashby

 | HOLES | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18
 | PAR | 4 |  | 4 |  | 3 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4 |  | 3 |  | 4 |  | 5 |  | 3 |  | 4 |  | 4 |  | 4 |  | 3 |  | 4 |  | 5
 | Stroke Index | 15 |  | 5 |  | 9 |  | 7 |  | 13 |  | 17 |  | 1 |  | 3 |  | 11 |  | 14 |  | 2 |  | 4 |  | 10 |  | 16 |  | 8 |  | 18 |  | 12 |  | 6
Games | Date | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Stroke | Pts | Total | H'Cap | Pts | Pars | Birdies
1 | 2021-04-21 00:00:00 | 5 |  | 6 |  | 6 |  | 6 |  | 6 |  | 4 |  | 6 |  | 7 |  | 4 |  | 6 |  | 6 |  | 5 |  | 6 |  | 5 |  | 6 |  | 3 |  | 4 |  | 7 |  |  | 13
2 | 2021-04-23 00:00:00 | 5 |  | 5 |  | 4 |  | 5 |  | 6 |  | 5 |  | 6 |  | 7 |  | 4 |  | 4 |  | 6 |  | 6 |  | 6 |  | 4 |  | 6 |  | 5 |  | 5 |  | 6 |  |  | 13
3 | 2021-04-26 00:00:00 | 6 |  | 7 |  | 5 |  | 7 |  | 6 |  | 4 |  | 6 |  | 6 |  | 4 |  | 4 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 7 |  |  | 13
4 | 2021-04-28 00:00:00 | 4 |  | 6 |  | 3 |  | 5 |  | 5 |  | 3 |  | 7 |  | 4 |  | 5 |  | 5 |  | 7 |  | 4 |  | 5 |  | 5 |  | 4 |  | 4 |  | 5 |  | 8 |  |  | 13
5 | 2021-04-30 00:00:00 | 6 |  | 5 |  | 3 |  | 7 |  | 5 |  | 3 |  | 8 |  | 5 |  | 4 |  | 6 |  | 6 |  | 4 |  | 5 |  | 4 |  | 7 |  | 4 |  | 4 |  | 7 |  |  | 13
6 | 2021-05-01 00:00:00 | 4 |  | 7 |  | 4 |  | 7 |  | 6 |  | 4 |  | 7 |  | 6 |  | 6 |  | 5 |  | 6 |  | 5 |  | 7 |  | 5 |  | 4 |  | 3 |  | 4 |  | 8 |  |  | 14
7 | 2021-05-05 00:00:00 | 4 |  | 5 |  | 5 |  | 5 |  | 4 |  | 3 |  | 7 |  | 6 |  | 5 |  | 6 |  | 6 |  | 3 |  | 5 |  | 5 |  | 5 |  | 4 |  | 4 |  | 7 |  |  | 14
8 | 2021-05-07 00:00:00 | 3 |  | 7 |  | 6 |  | 5 |  | 5 |  | 4 |  | 6 |  | 6 |  | 5 |  | 3 |  | 5 |  | 6 |  | 4 |  | 5 |  | 5 |  | 3 |  | 4 |  | 6 |  |  | 14
9 | 2021-05-09 00:00:00 | 4 |  | 6 |  | 4 |  | 6 |  | 6 |  | 5 |  | 8 |  | 5 |  | 4 |  | 5 |  | 8 |  | 6 |  | 5 |  | 6 |  | 4 |  | 5 |  | 4 |  | 7 |  |  | 14
10 | 2021-05-11 00:00:00 | 5 |  | 5 |  | 5 |  | 6 |  | 5 |  | 4 |  | 6 |  | 6 |  | 5 |  | 5 |  | 5 |  | 6 |  | 6 |  | 5 |  | 5 |  | 4 |  | 5 |  | 8 |  |  | 14
11 | 2021-05-12 00:00:00 | 6 |  | 6 |  | 5 |  | 7 |  | 5 |  | 4 |  | 6 |  | 6 |  | 4 |  | 4 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 3 |  | 4 |  | 8 |  |  | 14
12 | 2021-05-14 00:00:00 | 4 |  | 5 |  | 4 |  | 6 |  | 5 |  | 3 |  | 5 |  | 5 |  | 4 |  | 6 |  | 6 |  | 3 |  | 4 |  | 5 |  | 4 |  | 3 |  | 4 |  | 7 |  |  | 14
13 | 2021-05-19 00:00:00 | 4 |  | 6 |  | 4 |  | 5 |  | 5 |  | 4 |  | 8 |  | 5 |  | 5 |  | 4 |  | 4 |  | 5 |  | 6 |  | 6 |  | 5 |  | 3 |  | 5 |  | 6 |  |  | 15
14 | 2021-05-26 00:00:00 | 5 |  | 7 |  | 4 |  | 4 |  | 4 |  | 4 |  | 8 |  | 5 |  | 4 |  | 5 |  | 6 |  | 6 |  | 5 |  | 5 |  | 6 |  | 4 |  | 4 |  | 6 |  |  | 14
15 | 2021-06-02 00:00:00 | 5 |  | 6 |  | 5 |  | 7 |  | 4 |  | 3 |  | 6 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 4 |  | 4 |  | 5 |  | 4 |  | 5 |  | 7 |  |  | 14
16 | 2021-06-07 00:00:00 | 4 |  | 5 |  | 5 |  | 7 |  | 4 |  | 5 |  | 7 |  | 5 |  | 4 |  | 4 |  | 4 |  | 4 |  | 5 |  | 6 |  | 5 |  | 3 |  | 4 |  | 8 |  |  | 14
17 | 2021-06-09 00:00:00 | 5 |  | 5 |  | 4 |  | 5 |  | 6 |  | 5 |  | 7 |  | 4 |  | 4 |  | 5 |  | 7 |  | 4 |  | 5 |  | 5 |  | 5 |  | 4 |  | 6 |  | 6 |  |  | 15
18 | 2021-06-11 00:00:00 | 5 |  | 5 |  | 4 |  | 7 |  | 5 |  | 3 |  | 6 |  | 5 |  | 4 |  | 4 |  | 4 |  | 5 |  | 5 |  | 7 |  | 7 |  | 4 |  | 6 |  | 8 |  |  | 16
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
Average
18
Diff
My SI
Pars
Birdies