Spreadsheet: 807489d1669915697-struggling-to-get-the-correct-formula-countif-sumif-all-has-me-a-little-confused-help-booklet
Sheet: Summary 2022

Golfers | Surname | Selected | Winnings | Average |  | Total Overall |  |  |  |  | Person |  | Payout |  |  | Golfers | Surname | [NAME] | Dad | Stuart | TOTAL
M Fitzpatrick | Fitzpatrick |  |  |  |  | Total Bet |  |  |  |  | Me |  |  |  |  | A Ancer | Ancer
L Herbert | [NAME] |  |  |  |  | Total Winnings |  |  |  |  | Stuart |  |  |  |  | M Armitage | Armitage
A Rai | [NAME] |  |  |  |  | Total Profit/Loss |  |  |  |  | Dad |  |  |  |  | R Armour | [NAME]
T Hatton | Hatton |  |  |  |  |  |  |  |  |  |  |  | P/L |  |  | A Arnaus | Arnaus
V Hovland | Hovland |  |  |  |  |  |  |  |  |  |  |  | Avg P/L PW |  |  | R C Bello | Bello
[NAME] | Smith C |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
T Hoge | Hoge |  |  |  |  | Person |  | Winnings |  | Bet | P/L per Bet | AVG Group | AVG Golfer |  |  | C Bezuidenhout | Bezuidenhout
B [NAME] | [NAME] |  |  |  |  | Me |  |  |  |  |  |  |  |  |  | K Bradley | Bradley
T Finau | Finau |  |  |  |  | Stuart |  |  |  |  |  |  |  |  |  | D Burmester | Burmester
M Lee | [NAME] |  |  |  |  | Dad |  |  |  |  |  |  |  |  |  | S Burns | Burns
S Burns | Burns |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L Canter | Canter
S Power | Power |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P Cantaly | Cantlay
P Reed | Reed |  |  |  |  |  | Total Bet | Winnings | P/L |  |  | Total Bet | Winnings | P/L |  | P Casey | [NAME]
A Noren | [NAME] |  |  |  |  | Week 1 |  |  |  |  | Week 1 |  |  |  |  | [NAME] | Champ
A Wise | Wise |  |  |  |  | Week 2 |  |  |  |  | Week 2 |  |  |  |  | A Chesters | Chesters
M McNealy | McNealey |  |  |  |  | Week 3 |  |  |  |  | Week 3 |  |  |  |  | S Cink | Cink
J [NAME] | [NAME] |  |  |  |  | Week 4 |  |  |  |  | Week 4 |  |  |  |  | C Conners | Conners
A Ancer | Ancer |  |  |  |  | Week 5 |  |  |  |  | Week 5 |  |  |  |  | C [NAME] | [NAME]
S Munoz | Munoz |  |  |  |  | Week 6 |  |  |  |  | Week 6 |  |  |  |  | J Day | Day
K Streelman | Streelman |  |  |  |  | Week 7 |  |  |  |  | Week 7 |  |  |  |  | T Detry | Detry
S Scheffler | Scheffler |  |  |  |  | Week 8 |  |  |  |  | Week 8 |  |  |  |  | D Drysdale | Drysdale
A Meronk | Meronk |  |  |  |  | Week 9 |  |  |  |  | Week 9 |  |  |  |  | H English | English
A [NAME] | [NAME] |  |  |  |  | Week 10 |  |  |  |  | Week 10 |  |  |  |  | E Ferguson | Ferguson
C Morikawa | Morikawa |  |  |  |  | Week 11 |  |  |  |  | Week 11 |  |  |  |  | T Finau | Finau
R Hojggard | Hojggard |  |  |  |  | Week 12 |  |  |  |  |  |  |  |  |  | M Fitzpatrick | Fitzpatrick
M Homa | Homa |  |  |  |  | Week 13 |  |  |  |  |  |  |  |  |  | T Fleetwood | Fleetwood
[NAME] | [NAME] |  |  |  |  | Week 14 |  |  |  |  |  | % of winning weeks |  |  |  | R Fowler | Fowler
C [NAME] | [NAME] |  |  |  |  | Week 15 |  |  |  |  | Total |  |  |  |  | R Fox | Fox
R Fowler | Fowler |  |  |  |  | Week 16 |  |  |  |  | PGA |  |  |  |  | D Frittelli | Frittelli
R Langasque | Langasque |  |  |  |  | Week 17 |  |  |  |  | Euro |  |  |  |  | S [NAME] | [NAME]
J Smith | Smith J |  |  |  |  | Week 18 |  |  |  |  |  |  |  |  |  | D Ghim | Ghim
H Varner | Varner |  |  |  |  | Week 19 |  |  |  |  |  | % of weeks in profit |  |  |  | L Glover | Glover
P Larrazabal | Larrazabal |  |  |  |  | Week 20 |  |  |  |  | Total |  |  |  |  | T Gooch | [NAME]
P Cantaly | Cantlay |  |  |  |  | Week 21 |  |  |  |  | PGA |  |  |  |  | L Griffin | [NAME]
T Fleetwood | Fleetwood |  |  |  |  | Week 22 |  |  |  |  | Euro |  |  |  |  | E Grillo | Grillo
S Lowry | Lowry |  |  |  |  | Week 23 |  |  |  |  |  |  |  |  |  | A [NAME] | [NAME]
S Theegala | Theegala |  |  |  |  | Week 24 |  |  |  |  |  | % of weeks with Loss |  |  |  | J Harding | [NAME]
X Schauffele | Schauffele |  |  |  |  | Week 25 |  |  |  |  | Total |  |  |  |  | B Harman | Harman
H Matsuyama | Matsuyama |  |  |  |  | Week 26 |  |  |  |  | PGA |  |  |  |  | T Hatton | Hatton
[NAME] | Champ |  |  |  |  | Week 27 |  |  |  |  | Euro |  |  |  |  | R Henley | Henley
B Harman | Harman |  |  |  |  | Week 28 |  |  |  |  |  |  |  |  |  | L Herbert | [NAME]
R MacIntyre | MacIntyre |  |  |  |  | Week 29 |  |  |  |  |  | % of weeks no return |  |  |  | G Higgo | Higgo
R Palmer | Palmer |  |  |  |  | Week 30 |  |  |  |  | Total |  |  |  |  | H Higgs | Higgs
J Rose | Rose |  |  |  |  |  |  |  |  |  | PGA |  |  |  |  | C Hill | Hill
J Spieth | Speith |  |  |  |  |  |  |  |  |  | Euro |  |  |  |  | T Hoge | Hoge
R Henley | Henley |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R Hojggard | Hojggard
M Jordan | Jordan |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Homa | Homa
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B [NAME] | [NAME]
M Kinhult | Kinhult |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S Horsfield | [NAME]
S Stallings | Stallings |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V Hovland | Hovland
K Bradley | Bradley |  |  |  |  |  |  | stuarts due 4 weeks ater week 24 and week 9 |  |  |  |  |  |  |  | C Howell | Howell
S Horsfield | [NAME] |  |  |  |  |  |  | Due 24 |  |  |  |  |  |  |  | M Hughes | Hughes
C Bezuidenhout | Bezuidenhout |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SJ Im | Im
H English | English |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S Jamieson | Jamieson
R Fox | Fox |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D [NAME] | [NAME]
G Higgo | Higgo |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Jordan | Jordan
M Hughes | Hughes |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Kaymer | Kaymer
R Knox | Knox |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SW [NAME] | [NAME]
B [NAME] | Koepka |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T [NAME] | [NAME] T
J Kokrak | Kokrak |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Kinhult | Kinhult
L Oosthuizen | Oosthuizen |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C Kirk | [NAME]
M Pereira | Pereira |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K Kisner | [NAME]
T Pieters | Pieters |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R Knox | Knox
D Riley | Riley |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B [NAME] | Koepka
B Steele | Steele |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J Kokrak | Kokrak
C Tringale | Tringale |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J Kruyswijik | Kruyswijik
L Westwood | Westwood |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A [NAME] | [NAME]
B [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Laird | [NAME]
D Willett | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R Langasque | Langasque
M Wolff | Wolff |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B Langer | Langer
C Young | Young |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P Larrazabal | Larrazabal
P Rodgers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D Law | Law
T Gooch | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H Lebioda | Lebioda
A Scott | Scott |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Lee | [NAME]
J Harding | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T Lewis | Lewis
J Thomas | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D Lipsky | [NAME]
S Jamieson | Jamieson |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A Long | Long
R Armour | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S Lowry | Lowry
A Arnaus | Arnaus |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J Luiten | Luiten
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R MacIntyre | MacIntyre
D Burmester | Burmester |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H Matsuyama | Matsuyama
L Canter | Canter |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R McIlroy | McIlroy
C Conners | Conners |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M McNealy | McNealey
J Day | Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A Meronk | Meronk
T Detry | Detry |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G Migliozzi | Migliozzi
E Ferguson | Ferguson |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K Mitchell | Mitchell
D Frittelli | Frittelli |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C Morikawa | Morikawa
D Ghim | Ghim |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S Munoz | Munoz
L Glover | Glover |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K Na | Na
L Griffin | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J [NAME] | [NAME]
C Hill | Hill |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A Noren | [NAME]
C Howell | Howell |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L Oosthuizen | Oosthuizen
SW [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A Otaegui | Otaegui
T [NAME] | [NAME] T |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R Palmer | Palmer
K Kisner | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Pavon | [NAME]
A [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T Pendrith | Pendrith
M Laird | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E Pepperell | Pepperell
B Langer | Langer |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C Percy | Percy
H Lebioda | Lebioda |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Pereira | Pereira
A Long | Long |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
R McIlroy | McIlroy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P Perez | [NAME]
G Migliozzi | Migliozzi |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T Pieters | Pieters
K Mitchell | Mitchell |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I Poulter | Poulter
A Otaegui | Otaegui |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S Power | Power
M Pavon | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J Rahm | Rahm
T Pendrith | Pendrith |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A Rai | [NAME]
E Pepperell | Pepperell |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R Ramsey | Ramsey
C Percy | Percy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P Reed | Reed
I Poulter | Poulter |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D Riley | Riley
R Ramsey | Ramsey |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P Rodgers | Rodgers
A Rozner | Rozner |  |  |  |  |  |  | 1:1048576 |  |  |  |  |  |  |  | J Rose | Rose
K Samooja | Samooja |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A Rozner | Rozner
S Straka | Straka |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K Samooja | Samooja
J Veerman | Veerman |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X Schauffele | Schauffele
M Wallace | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S Scheffler | Scheffler
G Woodland | Woodland |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A Scott | Scott
M Armitage | Armitage |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Schwab | Scwab
R C Bello | Bello |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J Senior | Senior
P Casey | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Simpson
A Chesters | Chesters |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Smith
S Cink | Cink |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J Smith | Smith J
D Drysdale | Drysdale |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J Spieth | Speith
S [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S Stallings | Stallings
E Grillo | Grillo |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B Steele | Steele
H Higgs | Higgs |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S Straka | Straka
SJ Im | Im |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K Streelman | Streelman
D [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S Stricker | Stricker
M Kaymer | Kaymer |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A [NAME] | [NAME]
C Kirk | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S Theegala | Theegala
J Kruyswijik | Kruyswijik |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J Thomas | [NAME]
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C Tringale | Tringale
D Law | Law |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
T Lewis | Lewis |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H Varner | Varner
D Lipsky | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J Veerman | Veerman
J Luiten | Luiten |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Wallace | [NAME]
K Na | Na |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Warren | [NAME]
P Perez | Perez P |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B Watson | Watson
J Rahm | Rahm |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L Westwood | Westwood
M Schwab | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B [NAME] | [NAME]
J Senior | Senior |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D Willett | [NAME]
[NAME] | Simpson |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A Wise | Wise
S Stricker | Stricker |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Wolff | Wolff
A [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G Woodland | Woodland
M Warren | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C Young | Young
B Watson | Watson |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]