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

Picks |  | Colour | Winnings |  |  |  | Total Bet
Dad | Red |  |  |  |  |  | Winnings
Stuart | Green |  |  |  |  |  | P/L
Me | Grey
Week 1 - Pebble Beach Pro-Am |  |  |  |  |  |  | Week 2 - Genisis Invitational |  |  |  |  |  |  | Week 3 - Honda Classic |  |  |  |  |  |  | Week 4 - Arnold Palmer Invitational
[NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout
T Hoge | Grey | 1 | 45 | 2 | 56 |  | A Scott | Grey | 4 | 33 | 2 | 7.6 |  | A Noren | Green | 5 | 25 | 2 | 6 |  | S Scheffler | Grey | 1 | 12 | 2 | 16.4
M Fitzpatrick | Red | 6 | 22 | 2 | 6 |  | V Hovland | Green | 4 | 18 | 2 | 4.6 |  | B [NAME] | Red | 16 | 18 | 2 | 0 |  | B [NAME] | Red | 2 | 30 | 2 | 7
L Griffin | Grey | 16 | 30 | 2 | 0 |  | J Thomas | Green | 6 | 12 | 2 | 3.4 |  | C Young | Green | 16 | 33 | 2 | 0 |  | T Hatton | Green | 2 | 20 | 2 | 5
M McNealy | Grey | 33 | 18 | 2 | 0 |  | M Homa | Green | 10 | 33 | 2 | 2.53 |  | C Bezuidenhout | Grey | 25 | 40 | 2 | 0 |  | V Hovland | Green | 2 | 12 | 2 | 3.4
M Lee | Red | Miss | 35 | 2 | 0 |  | [NAME] | Red | 33 | 16 | 2 | 0 |  | I Poulter | Grey | 30 | 50 | 2 | 0 |  | L Herbert | Green | 7 | 110 | 2 | 23
B Harman | Red | Miss | 55 | 2 | 0 |  | H Matsuyama | Grey | 39 | 20 | 2 | 0 |  | M Hughes | Grey | 48 | 35 | 2 | 0 |  | T Gooch | Grey | 7 | 35 | 2 | 8
K Streelman | Green | Miss | 55 | 2 | 0 |  | B [NAME] | Red | Miss | 28 | 2 | 0 |  | P Reed | Red | Miss | 35 | 2 | 0 |  | M Fitzpatrick | Red | 9 | 20 | 2 | 5
A Rai | Green | Miss | 35 | 2 | 0 |  | S Burns | Grey | Miss | 28 | 2 | 0 |  | B Harman | Red | Miss | 30 | 2 | 0 |  | [NAME] | Red | Miss | 60 | 2 | 0
C Tringale | Green | Miss | 25 | 2 | 0 |  | M Fitzpatrick | Red | Void | 28 | 2 | 2 |  | L Herbert | Green | Miss | 55 | 2 | 0 |  | C Tringale | Grey | Miss | 40 | 2 | 0
 |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet
 |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings
 |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L
Week 5 - The Player Championship |  |  |  |  |  |  | Week 6 - Valspar Championship |  |  |  |  |  |  | Week 7 -  Valero Texas Open |  |  |  |  |  |  | Week 8 - The Masters Augusta National
[NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout
[NAME] | Red | 1 | 22 | 2 | 28.4 |  | A Noren | Green | 12 | 35 | 2 | 2 |  | A [NAME] | Green | 4 | 25 | 2 | 6 |  | S Scheffler | Grey | 1 | 10 | 2 | 14
V Hovland | Green | 9 | 14 | 2 | 3.8 |  | X Schauffele | Red | 12 | 16 | 2 | 1.05 |  | SW [NAME] | Red | 13 | 25 | 2 | 0 |  | [NAME] | Red | 3 | 10 | 2 | 3
T Hatton | Green | 13 | 35 | 2 | 0 |  | T Hatton | Green | 21 | 18 | 2 | 0 |  | K Streelman | Red | 18 | 35 | 2 | 0 |  | V Hovland | Green | 27 | 12 | 2 | 0
J [NAME] | Grey | 22 | 35 | 2 | 0 |  | H Varner | Red | 57 | 50 | 2 | 0 |  | C Conners | Grey | 35 | 12 | 2 | 0 |  | J [NAME] | Grey | 35 | 30 | 2 | 0
S Burns | Grey | 26 | 35 | 2 | 0 |  | L Oosthuizen | Red | 62 | 16 | 2 | 0 |  | B Steele | Grey | 48 | 45 | 2 | 0 |  | T Hoge | Grey | 39 | 90 | 2 | 0
A Ancer | Grey | 33 | 50 | 2 | 0 |  | C Morikawa | Green | 68 | 9 | 2 | 0 |  | R Palmer | Grey | 48 | 55 | 2 | 0 |  | T Hatton | Green | 52 | 33 | 2 | 0
L Herbert | Green | 68 | 100 | 2 | 0 |  | A Ancer | Grey | Miss | 22 | 2 | 0 |  | R Knox | Red | 61 | 45 | 2 | 0 |  | B Langer | Red | Miss | 300 | 2 | 0
L Westwood | Red | Miss | 90 | 2 | 0 |  | J Day | Grey | Miss | 40 | 2 | 0 |  | R Fowler | Green | Miss | 45 | 2 | 0 |  | L Herbert | Green | Miss | 125 | 2 | 0
M Fitzpatrick | Red | Miss | 28 | 2 | 0 |  | A Wise | Grey | Miss | 55 | 2 | 0 |  | A Ancer | Green | WD | 16 | 2 | 0 |  | L Oosthuizen | Red | WD | 28 | 2 | 0
 |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet
 |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings
 |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L
Week 9 - RBC Heritage |  |  |  |  |  |  | Week 10 - Mexico Open |  |  |  |  |  |  | Week 11 - Wells Fargo |  |  |  |  |  |  | Week 12 - Byron Nelson
[NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout
T Fleetwood | Red | 10 | 33 | 2 | 7 |  | A Wise | Green | 6 | 20 | 2 | 5 |  | K Bradley | Green | 2 | 18 | 2 | 4.6 |  | H Matsuyama | Green | 3 | 18 | 2 | 4.6
J [NAME] | Grey | 12 | 33 | 2 | 0.56 |  | A [NAME] | Grey | 15 | 55 | 2 | 0 |  | M Wolff | Red | 25 | 80 | 2 | 0 |  | X Schauffele | Red | 5 | 11 | 2 | 3.2
[NAME] | Green | 21 | 20 | 2 | 0 |  | A Rai | Green | 24 | 35 | 2 | 0 |  | T Hatton | Green | 37 | 20 | 2 | 0 |  | J Kokrak | Red | 17 | 33 | 2 | 0
T Hatton | Green | 26 | 30 | 2 | 0 |  | S Munoz | Green | 29 | 20 | 2 | 0 |  | T Finau | Grey | 41 | 16 | 2 | 0 |  | J [NAME] | Grey | 25 | 18 | 2 | 0
M McNealy | Grey | 26 | 20 | 2 | 0 |  | C Howell | Red | 33 | 35 | 2 | 0 |  | P Reed | Red | Miss | 30 | 2 | 0 |  | M McNealy | Green | 32 | 33 | 2 | 0
A Noren | Grey | 42 | 33 | 2 | 0 |  | D Ghim | Grey | 33 | 40 | 2 | 0 |  | K Streelman | Red | Miss | 45 | 2 | 0 |  | A Rai | Green | 46 | 80 | 2 | 0
D Willett | Red | 51 | 100 | 2 | 0 |  | A Ancer | Red | 42 | 14 | 2 | 0 |  | A Rai | Green | Miss | 40 | 2 | 0 |  | A Wise | Grey | 51 | 25 | 2 | 0
M Fitzpatrick | Red | Miss | 14 | 2 | 0 |  | P Reed | Red | 42 | 20 | 2 | 0 |  | K Mitchell | Grey | Miss | 35 | 2 | 0 |  | M Wolff | Red | Miss | 66 | 2 | 0
[NAME] | Green | Miss | 11 | 2 | 0 |  | K Streelman | Grey | 67 | 28 | 2 | 0 |  | S Power | Grey | Miss | 25 | 2 | 0 |  | [NAME] | Grey | Miss | 14 | 2 | 0
 |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet
 |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings
 |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L
Week 13 - PGA Championship |  |  |  |  |  |  | Week 14 - Charles Schwab |  |  |  |  |  |  | Week 15 - The Memorial Tournament |  |  |  |  |  |  | Week 16 - RBC Canadian Open
[NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout
M Fitzpatrick | Red | 5 | 33 | 2 | 7.6 |  | P Reed | Red | 7 | 50 | 2 | 11 |  | P Cantlay | Grey | 3 | 11 | 2 | 3.2 |  | M Fitzpatrick | Red | 10 | 14 | 2 | 3.8
[NAME] | Red | 13 | 18 | 2 | 0 |  | H Varner | Red | 27 | 40 | 2 | 0 |  | [NAME] | Red | 13 | 14 | 2 | 0 |  | H Varner | Red | 13 | 25 | 2 | 0
T Hatton | Green | 13 | 55 | 2 | 0 |  | T Fleetwood | Grey | 35 | 25 | 2 | 0 |  | D Riley | Green | 13 | 35 | 2 | 0 |  | A Rai | Green | 13 | 28 | 2 | 0
L Herbert | Green | 13 | 200 | 2 | 0 |  | L Herbert | Green | 48 | 70 | 2 | 0 |  | A Rai | Grey | 26 | 125 | 2 | 0 |  | S Munoz | Green | 25 | 66 | 2 | 0
S Burns | Grey | 20 | 33 | 2 | 0 |  | S Munoz | Green | 48 | 40 | 2 | 0 |  | L Herbert | Green | 48 | 100 | 2 | 0 |  | H Lebioda | Green | 28 | 100 | 2 | 0
V Hovland | Red | 41 | 20 | 2 | 0 |  | J Kokrak | Grey | 67 | 28 | 2 | 0 |  | V Hovland | Green | 51 | 18 | 2 | 0 |  | M Hughes | Grey | 28 | 45 | 2 | 0
S Munoz | Green | 55 | 100 | 2 | 0 |  | A Rai | Green | 68 | 70 | 2 | 0 |  | P Reed | Red | 53 | 40 | 2 | 0 |  | A [NAME] | Grey | 35 | 25 | 2 | 0
B [NAME] | Grey | 55 | 33 | 2 | 0 |  | T Hoge | Grey | Miss | 45 | 2 | 0 |  | M Fitzpatrick | Red | Miss | 18 | 2 | 0 |  | [NAME] | Red | 48 | 10 | 2 | 0
C Bezuidenhout | Grey | Miss | 100 | 2 | 0 |  | A Ancer | Red | Miss | 28 | 2 | 0 |  | T Hoge | Grey | Miss | 66 | 2 | 0 |  | S Theegala | Grey | 53 | 33 | 2 | 0
 |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet
 |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings
 |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L
Week 17 - The US Open |  |  |  |  |  |  | Week 18 -Travellers Championship |  |  |  |  |  |  | Week 19 - The 3M Open |  |  |  |  |  |  | Week 20 - Rocket Mortgage Classis
[NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout
M Fitzpatrick | Red | 1 | 18 | 2 | 23.6 |  | S Scheffler | Red | 13 | 7.5 | 2 | 0 |  | T Hoge | Grey | 4 | 60 | 2 | 13 |  | R Henley | Green | 10 | 40 | 2 | 6.75
C Morikawa | Green | 5 | 20 | 2 | 5 |  | T Finau | Green | 13 | 22 | 2 | 0 |  | [NAME] | Red | 16 | 40 | 2 | 0 |  | S Stallings | Grey | 10 | 40 | 2 | 6.75
S Power | Grey | 12 | 70 | 2 | 7.5 |  | K Bradley | Red | 19 | 40 | 2 | 0 |  | C [NAME] | Green | 16 | 20 | 2 | 0 |  | C [NAME] | Green | 14 | 22 | 2 | 0
M Lee | Red | 27 | 200 | 2 | 0 |  | H English | Grey | 19 | 80 | 2 | 0 |  | R Palmer | Red | 31 | 45 | 2 | 0 |  | A [NAME] | Green | 37 | 33 | 2 | 0
S Burns | Green | 27 | 20 | 2 | 0 |  | A Rai | Green | 40 | 33 | 2 | 0 |  | R Fowler | Red | 38 | 40 | 2 | 0 |  | K Streelman | Grey | 49 | 40 | 2 | 0
J Rose | Grey | 37 | 50 | 2 | 0 |  | H Varner | Red | 43 | 28 | 2 | 0 |  | A [NAME] | Green | 38 | 18 | 2 | 0 |  | K Kisner | Red | Miss | 40 | 2 | 0
T Finau | Red | Miss | 25 | 2 | 0 |  | C [NAME] | Grey | 56 | 66 | 2 | 0 |  | B Steele | Green | Miss | 25 | 2 | 0 |  | H English | Red | Miss | 60 | 2 | 0
L Herbert | Green | Miss | 175 | 2 | 0 |  | D Riley | Green | 64 | 66 | 2 | 0 |  | S Theegala | Grey | Miss | 18 | 2 | 0 |  | R Palmer | Red | Miss | 60 | 2 | 0
B [NAME] | Grey | Miss | 35 | 2 | 0 |  | M Pereira | Grey | Miss | 35 | 2 | 0 |  | G Higgo | Grey | Miss | 80 | 2 | 0 |  | M McNealy | Grey | Miss | 28 | 2 | 0
 |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet
 |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings
 |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L
Week 21 - Wyndham Championship |  |  |  |  |  |  | Week 22 - St Jude Championship |  |  |  |  |  |  | Week 23 - BMW Championship |  |  |  |  |  |  | Week 24 - Tour Championship
[NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout
R Henley | Green | 5 | 20 | 2 | 5 |  | T Finau | Green | 5 | 18 | 2 | 4.6 |  | P Cantlay | Red | 1 | 11 | 2 | 15.2 |  | [NAME] | Red |  | 11 | 2 | 0
A Wise | Grey | 13 | 33 | 2 | 0 |  | M Fitzpatrick | Red | 5 | 16 | 2 | 4.2 |  | L Herbert | Green | 15 | 100 | 2 | 0 |  | M Fitzpatrick | Red |  | 22 | 2 | 0
M Laird | Grey | 47 | 55 | 2 | 0 |  | [NAME] | Red | 13 | 11 | 2 | 0 |  | A Wise | Grey | 15 | 40 | 2 | 0 |  | X Schauffele | Red |  | 5 | 2 | 2.25
J Rose | Grey | 54 | 35 | 2 | 0 |  | S Burns | Grey | 20 | 25 | 2 | 0 |  | T Finau | Green | 28 | 11 | 2 | 0 |  | V Hovland | Green |  | 35 | 2 | 0
B Harman | Green | 71 | 25 | 2 | 0 |  | T Hatton | Green | 31 | 33 | 2 | 0 |  | V Hovland | Green | 35 | 20 | 2 | 0 |  | C Morikawa | Green |  | 45 | 2 | 0
A Rai | Green | 71 | 66 | 2 | 0 |  | M Pereira | Grey | 42 | 70 | 2 | 0 |  | B [NAME] | Grey | 35 | 45 | 2 | 0 |  | J Spieth | Green |  | 35 | 2 | 0
[NAME] | Red | Miss | 35 | 2 | 0 |  | A Rai | Green | 51 | 100 | 2 | 0 |  | M Fitzpatrick | Red | 48 | 11 | 2 | 0 |  | S Straka | Grey |  | 60 | 2 | 0
D Willett | Red | Miss | 66 | 2 | 0 |  | J Spieth | Red | Miss | 20 | 2 | 0 |  | S Power | Red | 65 | 80 | 2 | 0 |  | S Burns | Grey |  | 12 | 2 | 0
R Fowler | Red | Miss | 80 | 2 | 0 |  | S Power | Grey | Miss | 55 | 2 | 0 |  | [NAME] | Grey | WD | 11 | 2 | 0 |  | S Stallings | Grey |  | 66 | 2 | 0
 |  |  | Total Bet |  | 18 |  |  |  |  | Total Bet |  | 18 |  |  |  |  | Total Bet |  | 18 |  |  |  |  | Total Bet |  | 18
 |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings
 |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L
Week 25 - Shriners Childrens Open |  |  |  |  |  |  | Week 26 - ZOZO Championship |  |  |  |  |  |  | Week 27 - The CJ Cup |  |  |  |  |  |  | Week 28 -Bermuda Chapionship
[NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout
T Hoge | Red | 4 | 25 | 2 | 6 |  | T Hoge | Red | 9 | 22 | 2 | 3.6 |  | S Scheffler | Red | 45 | 9 | 2 | 0 |  | R Knox | Red | 49 | 25 | 2 | 0
M Homa | Green | 20 | 12 | 2 | 0 |  | T Hatton | Red | 45 | 18 | 2 | 0 |  | M Fitzpatrick | Red | 13 | 14 | 2 | 0 |  | L Glover | Red | 63 | 50 | 2 | 0
L Herbert | Green | 20 | 35 | 2 | 0 |  | L Herbert | Red | 59 | 40 | 2 | 0 |  | S Lowry | Red | 23 | 22 | 2 | 0 |  | [NAME] | Red | 35 | 35 | 2 | 0
T Pendrith | Green | 44 | 33 | 2 | 0 |  | V Hovland | Green | 5 | 10 | 2 | 3.2 |  | V Hovland | Green | 21 | 14 | 2 | 0 |  | A Rai | Green | 54 | 16 | 2 | 0
A Noren | Grey | 44 | 28 | 2 | 0 |  | C Morikawa | Green | 45 | 11 | 2 | 0 |  | C Young | Green | 23 | 18 | 2 | 0 |  | P Rodgers | Green | 3 | 18 | 2 | 4.6
T Detry | Grey | 69 | 35 | 2 | 0 |  | C [NAME] | Green | 29 | 30 | 2 | 0 |  | T Fleetwood | Green | 4 | 45 | 2 | 10 |  | A Long | Green | 44 | 30 | 2 | 0
R Fowler | Red | Miss | 35 | 2 | 0 |  | T [NAME] | Grey | 25 | 8.5 | 2 | 0 |  | M Homa | Grey | 23 | 18 | 2 | 0 |  | R Armour | Grey | Miss | 50 | 2 | 0
G Higgo | Grey | Miss | 70 | 2 | 0 |  | S Theegala | Grey | 5 | 30 | 2 | 7 |  | B [NAME] | Grey | 7 | 33 | 2 | 7.6 |  | C Percy | Grey | 35 | 35 | 2 | 0
G Woodland | Red | WD | 55 | 2 | 0 |  | A Rai | Grey | 36 | 50 | 2 | 0 |  | A Noren | Grey | 37 | 45 | 2 | 0 |  | A Meronk | Grey | Miss | 18 | 2 | 0
 |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet
 |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings
 |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L
Week 29 - WWT Championship |  |  |  |  |  |  | Week 30
[NAME] |  | Finish | Price | Bet E/W | Payout |  | [NAME] |  | Finish | Price | Bet E/W | Payout
B [NAME] | Red | 56 | 11 | 2 | 0 |  |  | Red |  |  | 2 | 0
S Power | Red | 3 | 25 | 2 | 6 |  |  | Red |  |  | 2 | 0
[NAME] | Red | Miss | 50 | 2 | 0 |  |  | Red |  |  | 2 | 0
T Finau | Green | Miss | 10 | 2 | 0 |  |  | Green |  |  | 2 | 0
T Hoge | Green | Miss | 16 | 2 | 0 |  |  | Green |  |  | 2 | 0
P Rodgers | Green | 27 | 40 | 2 | 0 |  |  | Green |  |  | 2 | 0
M McNealy | Grey | 10 | 18 | 2 | 2.76 |  |  | Grey |  |  | 2 | 0
S Munoz | Grey | 56 | 40 | 2 | 0 |  |  | Grey |  |  | 2 | 0
D Frittelli | Grey | 59 | 80 | 2 | 0 |  |  | Grey |  |  | 2 | 0
 |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  | 0
 |  |  | Winnings |  |  |  |  |  |  | Winnings |  | 0
 |  |  | P/L |  |  |  |  |  |  | P/L |  | 0