Spreadsheet: 807646d1669982459-struggling-to-get-the-correct-formula-countif-sumif-all-has-me-a-little-confused-help-booklet-1-
Sheet: Sheet2

Golfers | Surname | Selected | Winnings | [NAME] | Surname | Selected | Winnings | [NAME] | Surname | Selected | Winnings |  |  | Golfers
A Ancer | Ancer |  |  | V Hovland | Hovland |  |  | C Percy | Percy |  |  |  |  | A Ancer |  | B [NAME] |  | R Palmer |  | A Wise
M Armitage | Armitage |  |  | C Howell | Howell |  |  | M Pereira | Pereira |  |  |  |  | M Armitage |  | S Horsfield |  | M Pavon |  | M Wolff
R Armour | [NAME] |  |  | M Hughes | Hughes |  |  | P Perez | Perez P |  |  |  |  | R Armour |  | V Hovland |  | T Pendrith |  | G Woodland
A Arnaus | Arnaus |  |  | SJ Im | Im |  |  | [NAME] | [NAME] |  |  |  |  | A Arnaus |  | C Howell |  | E Pepperell |  | C Young
R C Bello | Bello |  |  | S Jamieson | Jamieson |  |  | T Pieters | Pieters |  |  |  |  | R C Bello |  | M Hughes |  | C Percy |  | [NAME]
[NAME] | [NAME] |  |  | D [NAME] | [NAME] |  |  | I Poulter | Poulter |  |  |  |  | [NAME] |  | SJ Im |  | M Pereira
C Bezuidenhout | Bezuidenhout |  |  | M Jordan | Jordan |  |  | S Power | Power |  |  |  |  | C Bezuidenhout |  | S Jamieson |  | P Perez
K Bradley | Bradley |  |  | M Kaymer | Kaymer |  |  | J Rahm | Rahm |  |  |  |  | K Bradley |  | D [NAME] |  | [NAME]
D Burmester | Burmester |  |  | SW [NAME] | [NAME] |  |  | A Rai | [NAME] |  |  |  |  | D Burmester |  | M Jordan |  | T Pieters
S Burns | Burns |  |  | T [NAME] | [NAME] T |  |  | R Ramsey | Ramsey |  |  |  |  | S Burns |  | M Kaymer |  | I Poulter
L Canter | Canter |  |  | M Kinhult | Kinhult |  |  | P Reed | Reed |  |  |  |  | L Canter |  | SW [NAME] |  | S Power
P Cantaly | Cantlay |  |  | C Kirk | [NAME] |  |  | D Riley | Riley |  |  |  |  | P Cantaly |  | T [NAME] |  | J Rahm
P Casey | [NAME] |  |  | K Kisner | [NAME] |  |  | P Rodgers | Rodgers |  |  |  |  | P Casey |  | M Kinhult |  | A Rai
[NAME] | Champ |  |  | R Knox | Knox |  |  | J Rose | Rose |  |  |  |  | [NAME] |  | C Kirk |  | R Ramsey
A Chesters | Chesters |  |  | B [NAME] | Koepka |  |  | A Rozner | Rozner |  |  |  |  | A Chesters |  | K Kisner |  | P Reed
S Cink | Cink |  |  | J Kokrak | Kokrak |  |  | K Samooja | Samooja |  |  |  |  | S Cink |  | R Knox |  | D Riley
C Conners | Conners |  |  | J Kruyswijik | Kruyswijik |  |  | X Schauffele | Schauffele |  |  |  |  | C Conners |  | B [NAME] |  | P Rodgers
C [NAME] | [NAME] |  |  | A [NAME] | [NAME] |  |  | S Scheffler | Scheffler |  |  |  |  | C [NAME] |  | J Kokrak |  | J Rose
J Day | Day |  |  | M Laird | [NAME] |  |  | M Schwab | [NAME] |  |  |  |  | J Day |  | J Kruyswijik |  | A Rozner
T Detry | Detry |  |  | R Langasque | Langasque |  |  | A Scott | Scott |  |  |  |  | T Detry |  | A [NAME] |  | K Samooja
D Drysdale | Drysdale |  |  | B Langer | Langer |  |  | J Senior | Senior |  |  |  |  | D Drysdale |  | M Laird |  | X Schauffele
H English | English |  |  | [NAME] | [NAME] |  |  | [NAME] | Simpson |  |  |  |  | H English |  | R Langasque |  | S Scheffler
E Ferguson | Ferguson |  |  | P Larrazabal | Larrazabal |  |  | [NAME] | Smith C |  |  |  |  | E Ferguson |  | B Langer |  | M Schwab
T Finau | Finau |  |  | D Law | Law |  |  | J Smith | Smith J |  |  |  |  | T Finau |  | [NAME] |  | A Scott
M Fitzpatrick | Fitzpatrick |  |  | H Lebioda | Lebioda |  |  | J Spieth | Speith |  |  |  |  | M Fitzpatrick |  | P Larrazabal |  | J Senior
T Fleetwood | Fleetwood |  |  | M Lee | [NAME] |  |  | S Stallings | Stallings |  |  |  |  | T Fleetwood |  | D Law |  | [NAME]
R Fowler | Fowler |  |  | T Lewis | Lewis |  |  | B Steele | Steele |  |  |  |  | R Fowler |  | H Lebioda |  | [NAME]
R Fox | Fox |  |  | D Lipsky | [NAME] |  |  | S Straka | Straka |  |  |  |  | R Fox |  | M Lee |  | J Smith
D Frittelli | Frittelli |  |  | A Long | Long |  |  | K Streelman | Streelman |  |  |  |  | D Frittelli |  | T Lewis |  | J Spieth
S [NAME] | [NAME] |  |  | S Lowry | Lowry |  |  | S Stricker | Stricker |  |  |  |  | S [NAME] |  | D Lipsky |  | S Stallings
D Ghim | Ghim |  |  | J Luiten | Luiten |  |  | A [NAME] | [NAME] |  |  |  |  | D Ghim |  | A Long |  | B Steele
L Glover | Glover |  |  | R MacIntyre | MacIntyre |  |  | S Theegala | Theegala |  |  |  |  | L Glover |  | S Lowry |  | S Straka
T Gooch | [NAME] |  |  | H Matsuyama | Matsuyama |  |  | J Thomas | [NAME] |  |  |  |  | T Gooch |  | J Luiten |  | K Streelman
L Griffin | [NAME] |  |  | R McIlroy | McIlroy |  |  | C Tringale | Tringale |  |  |  |  | L Griffin |  | R MacIntyre |  | S Stricker
E Grillo | Grillo |  |  | M McNealy | McNealey |  |  | [NAME] | [NAME] |  |  |  |  | E Grillo |  | H Matsuyama |  | A [NAME]
A [NAME] | [NAME] |  |  | A Meronk | Meronk |  |  | H Varner | Varner |  |  |  |  | A [NAME] |  | R McIlroy |  | S Theegala
J Harding | [NAME] |  |  | G Migliozzi | Migliozzi |  |  | J Veerman | Veerman |  |  |  |  | J Harding |  | M McNealy |  | J Thomas
B Harman | Harman |  |  | K Mitchell | Mitchell |  |  | M Wallace | [NAME] |  |  |  |  | B Harman |  | A Meronk |  | C Tringale
T Hatton | Hatton |  |  | C Morikawa | Morikawa |  |  | M Warren | [NAME] |  |  |  |  | T Hatton |  | G Migliozzi |  | [NAME]
R Henley | Henley |  |  | S Munoz | Munoz |  |  | B Watson | Watson |  |  |  |  | R Henley |  | K Mitchell |  | H Varner
L Herbert | [NAME] |  |  | K Na | Na |  |  | L Westwood | Westwood |  |  |  |  | L Herbert |  | C Morikawa |  | J Veerman
G Higgo | Higgo |  |  | J [NAME] | [NAME] |  |  | B [NAME] | [NAME] |  |  |  |  | G Higgo |  | S Munoz |  | M Wallace
H Higgs | Higgs |  |  | A Noren | [NAME] |  |  | D Willett | [NAME] |  |  |  |  | H Higgs |  | K Na |  | M Warren
C Hill | Hill |  |  | L Oosthuizen | Oosthuizen |  |  | A Wise | Wise |  |  |  |  | C Hill |  | J [NAME] |  | B Watson
T Hoge | Hoge |  |  | A Otaegui | Otaegui |  |  | M Wolff | Wolff |  |  |  |  | T Hoge |  | A Noren |  | L Westwood
R Hojggard | Hojggard |  |  | R Palmer | Palmer |  |  | G Woodland | Woodland |  |  |  |  | R Hojggard |  | L Oosthuizen |  | B [NAME]
M Homa | Homa |  |  | M Pavon | [NAME] |  |  | C Young | Young |  |  |  |  | M Homa |  | A Otaegui |  | D Willett
B [NAME] | [NAME] |  |  | T Pendrith | Pendrith |  |  | [NAME] | [NAME]
S Horsfield | [NAME] |  |  | E Pepperell | Pepperell