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

 |  | Colour | Winnings |  |  |  | Total Bet
Dad | Red |  |  |  |  |  | Winnings
Stuart | Green |  |  |  |  |  | P/L
Me | Grey
Week 1 - Abu Dhabi HSBC Championship |  |  |  |  |  |  | Week 2 - Dubai Classic |  |  |  |  |  |  | Week 3 - Qatar Masters |  |  |  |  |  |  | Week 4 - ISPS Handa 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
V Hovland | Green | 4 | 10 | 2 | 3 |  |  | Red |  |  | 0 | 0 |  | M Kinhult | Red | 3 | 33 | 2 | 7.6 |  | P Larrazabal | Grey | 1 | 22 | 2 | 28.4
T Hatton | Green | 6 | 20 | 2 | 2.5 |  |  | Green |  |  | 0 | 0 |  | A Meronk | Green | 3 | 25 | 2 | 6 |  | S Jamieson | Red | 10 | 40 | 2 | 1.8
[NAME] | Red | 12 | 40 | 2 | 0 |  | S Horsfield | Grey | 4 |  | 2 | 1.52 |  | M Jordan | Grey | 5 | 50 | 2 | 9.43 |  | M Jordan | Grey | 15 | 40 | 2 | 0
R McIlroy | Grey | 12 | 7 | 2 | 0 |  | T Hatton | Green | 4 |  | 2 | 0.33 |  | J Harding | Green | 5 | 22 | 2 | 4.63 |  | L Canter | Green | 30 | 25 | 2 | 0
B [NAME] | Grey | 12 | 33 | 2 | 0 |  | [NAME] | Red | 4 |  | 2 | 0.56 |  | R Langasque | Red | 21 | 22 | 2 | 0 |  | B [NAME] | Red | 38 | 16 | 2 | 0
L Westwood | Red | 20 | 70 | 2 | 0 |  |  | Green |  |  | 0 | 0 |  | M Pavon | Green | 27 | 30 | 2 | 0 |  | J Veerman | Green | 38 | 55 | 2 | 0
A Arnaus | Green | 20 | 66 | 2 | 0 |  |  | Grey |  |  | 0 | 0 |  | D Burmester | Grey | 40 | 12 | 2 | 0 |  | K Samooja | Grey | 38 | 55 | 2 | 0
M Lee | Grey | 35 | 28 | 2 | 0 |  |  | Grey |  |  | 0 | 0 |  | J Smith | Grey | 76 | 16 | 2 | 0 |  | R Langasque | Green | Miss | 25 | 2 | 0
R MacIntyre | Red | Miss | 30 | 2 | 0 |  |  | Red |  |  | 0 | 0 |  | C Hill | Red | WD | 35 | 2 | 0 |  | M Kinhult | Red | WD | 33 | 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 Irish Open |  |  |  |  |  |  | Week 6 - The Scottish Open |  |  |  |  |  |  | Week 7 - The Open |  |  |  |  |  |  | Week 8 - BMW PGA 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
L Herbert | Red | 9 | 25 | 2 | 3 |  | M Fitzpatrick | Red | 6 | 14 | 2 | 3.8 |  | P Cantlay | Red | 8 | 20 | 2 | 5 |  | M Fitzpatrick | Red | 42 | 10 | 2 | 0
A Rai | Green | 9 | 22 | 2 | 2.7 |  | R Fox | Red | 47 | 33 | 2 | 0 |  | J Spieth | Green | 8 | 12 | 2 | 3.4 |  | S Lowry | Red | 2 | 12 | 2 | 16.4
R MacIntyre | Red | 13 | 33 | 2 | 0 |  | M Lee | Red | Miss | 60 | 2 | 0 |  | L Herbert | Green | 15 | 70 | 2 | 0 |  | M Lee | Red | 42 | 100 | 2 | 0
R Langasque | Grey | 30 | 30 | 2 | 0 |  | L Herbert | Green | Miss | 40 | 2 | 0 |  | M Fitzpatrick | Red | 21 | 14 | 2 | 0 |  | A Rai | Green | Miss | 55 | 2 | 0
R Ramsey | Green | 37 | 40 | 2 | 0 |  | H Matsuyama | Green | Miss | 25 | 2 | 0 |  | B [NAME] | Grey | 21 | 66 | 2 | 0 |  | L Herbert | Green | Miss | 55 | 2 | 0
T Pieters | Grey | 37 | 14 | 2 | 0 |  | A Rai | Green | Miss | 55 | 2 | 0 |  | T Finau | Green | 28 | 30 | 2 | 0 |  | J Smith | Green | Miss | 45 | 2 | 0
P Larrazabal | Grey | 46 | 25 | 2 | 0 |  | B [NAME] | Grey | Miss | 35 | 2 | 0 |  | J [NAME] | Grey | 53 | 33 | 2 | 0 |  | R Langasque | Grey | 57 | 100 | 2 | 0
M Lee | Red | 58 | 28 | 2 | 0 |  | A Meronk | Grey | Miss | 50 | 2 | 0 |  | M Homa | Red | Miss | 35 | 2 | 0 |  | R Hojggard | Grey | 18 | 66 | 2 | 0
T Hatton | Green | Miss | 14 | 2 | 0 |  | J Smith | Grey | 24 | 66 | 2 | 0 |  | J Rose | Grey | WD | 40 | 2 | 0 |  | M Wallace | Grey | Miss | 50 | 2 | 0
 |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet
 |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings
 |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L
Week 9 - Italian Open |  |  |  |  |  |  | Week 10 - Alfred Dunhill Links Championship |  |  |  |  |  |  | Week 11 - DP World 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
M Fitzpatrick | Red | 2 | 7.5 | 2 | 2.5 |  | T Hatton | Red | 7 | 10 | 2 | 3 |  | T Hatton | Green | 2 | 11 | 2 | 3.2 |  |  | Red |  |  | 2 | 0
[NAME] | Grey | 3 | 40 | 2 | 9 |  | R Hojggard | Grey | 17 | 30 | 2 | 0 |  | M Fitzpatrick | Red | 5 | 6 | 2 | 2.2 |  |  | Red |  |  | 2 | 0
L Herbert | Green | 5 | 40 | 2 | 9 |  | R MacIntyre | Green | 20 | 20 | 2 | 0 |  | A Meronk | Green | 7 | 50 | 2 | 11 |  |  | Red |  |  | 2 | 0
A Rai | Green | 5 | 40 | 2 | 9 |  | M Fitzpatrick | Red | 22 | 9 | 2 | 0 |  | R Hojggard | Grey | 7 | 18 | 2 | 4.6 |  |  | Green |  |  | 2 | 0
E Pepperell | Red | 12 | 40 | 2 | 0 |  | T Pieters | Grey | 28 | 18 | 2 | 0 |  | S Horsfield | Grey | 16 | 45 | 2 | 0 |  |  | Green |  |  | 2 | 0
R Hojggard | Grey | 27 | 30 | 2 | 0 |  | [NAME] | Green | 36 | 22 | 2 | 0 |  | A Otaegui | Grey | 16 | 45 | 2 | 0 |  |  | Green |  |  | 2 | 0
V Hovland | Green | 34 | 8 | 2 | 0 |  | G Migliozzi | Grey | 75 | 50 | 2 | 0 |  | R Fox | Red | 19 | 16 | 2 | 0 |  |  | Grey |  |  | 2 | 0
M Lee | Red | 86 | 30 | 2 | 0 |  | S Lowry | Red | 87 | 9 | 2 | 0 |  | A Rozner | Green | 34 | 45 | 2 | 0 |  |  | Grey |  |  | 2 | 0
P Larrazabal | Grey | RTD | 55 | 2 | 0 |  | J Smith | Green | DQ | 25 | 2 | 0 |  | E Ferguson | Red | 42 | 66 | 2 | 0 |  |  | Grey |  |  | 2 | 0
 |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet |  |  |  |  |  |  | Total Bet
 |  |  | Winnings |  |  |  |  |  |  | Winnings |  | 3 |  |  |  |  | Winnings |  |  |  |  |  |  | Winnings
 |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L |  |  |  |  |  |  | P/L