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

Week 1 |  |  |  |  | Week 11 |  |  |  |  | Week 21 |  |  |  |  |  | Week 1
Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  |  | Person | Winnings | Bet | P/L per Bet
Me |  | 6 |  |  | Me |  | 66 |  |  | Me |  | 126 |  |  |  | Me |  | 6
Stuart |  | 6 |  |  | Stuart |  | 66 |  |  | Stuart |  | 126 |  |  |  | Stuart |  | 6
Dad |  | 6 |  |  | Dad |  | 66 |  |  | Dad |  | 126 |  |  |  | Dad |  | 6
Week 2 |  |  |  |  | Week 12 |  |  |  |  | Week 22 |  |  |  |  |  | Week 2
Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  |  | Person | Winnings | Bet | P/L per Bet
Me |  | 12 |  |  | Me |  | 72 |  |  | Me |  | 132 |  |  |  | Me |  | 8
Stuart |  | 12 |  |  | Stuart |  | 72 |  |  | Stuart |  | 132 |  |  |  | Stuart |  | 8
Dad |  | 12 |  |  | Dad |  | 72 |  |  | Dad |  | 132 |  |  |  | Dad |  | 8
Week 3 |  |  |  |  | Week 13 |  |  |  |  | Week 23 |  |  |  |  |  | Week 3
Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  |  | Person | Winnings | Bet | P/L per Bet
Me |  | 18 |  |  | Me |  | 78 |  |  | Me |  | 138 |  |  |  | Me |  | 14
Stuart |  | 18 |  |  | Stuart |  | 78 |  |  | Stuart |  | 138 |  |  |  | Stuart |  | 14
Dad |  | 18 |  |  | Dad |  | 78 |  |  | Dad |  | 138 |  |  |  | Dad |  | 14
Week 4 |  |  |  |  | Week 14 |  |  |  |  | Week 24 |  |  |  |  |  | Week 4
Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  |  | Person | Winnings | Bet | P/L per Bet
Me |  | 24 |  |  | Me |  | 84 |  |  | Me |  | 144 |  |  |  | Me |  | 20
Stuart |  | 24 |  |  | Stuart |  | 84 |  |  | Stuart |  | 144 |  |  |  | Stuart |  | 20
Dad |  | 24 |  |  | Dad |  | 84 |  |  | Dad |  | 144 |  |  |  | Dad |  | 20
Week 5 |  |  |  |  | Week 15 |  |  |  |  | Week 25 |  |  |  |  |  | Week 5
Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  |  | Person | Winnings | Bet | P/L per Bet
Me |  | 30 |  |  | Me |  | 90 |  |  | Me |  | 150 |  |  |  | Me |  | 30
Stuart |  | 30 |  |  | Stuart |  | 90 |  |  | Stuart |  | 150 |  |  |  | Stuart |  | 30
Dad |  | 30 |  |  | Dad |  | 90 |  |  | Dad |  | 150 |  |  |  | Dad |  | 30
Week 6 |  |  |  |  | Week 16 |  |  |  |  | Week 26 |  |  |  |  |  | Week 6
Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  |  | Person | Winnings | Bet | P/L per Bet
Me |  | 36 |  |  | Me |  | 96 |  |  | Me |  | 156 |  |  |  | Me |  | 36
Stuart |  | 36 |  |  | Stuart |  | 96 |  |  | Stuart |  | 156 |  |  |  | Stuart |  | 36
Dad |  | 36 |  |  | Dad |  | 96 |  |  | Dad |  | 156 |  |  |  | Dad |  | 36
Week 7 |  |  |  |  | Week 17 |  |  |  |  | Week 27 |  |  |  |  |  | Week 7
Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  |  | Person | Winnings | Bet | P/L per Bet
Me |  | 42 |  |  | Me |  | 102 |  |  | Me |  | 162 |  |  |  | Me |  | 42
Stuart |  | 42 |  |  | Stuart |  | 102 |  |  | Stuart |  | 162 |  |  |  | Stuart |  | 42
Dad |  | 42 |  |  | Dad |  | 102 |  |  | Dad |  | 162 |  |  |  | Dad |  | 42
Week 8 |  |  |  |  | Week 18 |  |  |  |  | Week 28 |  |  |  |  |  | Week 8
Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  |  | Person | Winnings | Bet | P/L per Bet
Me |  | 48 |  |  | Me |  | 108 |  |  | Me |  | 168 |  |  |  | Me |  | 48
Stuart |  | 48 |  |  | Stuart |  | 108 |  |  | Stuart |  | 168 |  |  |  | Stuart |  | 48
Dad |  | 48 |  |  | Dad |  | 108 |  |  | Dad |  | 168 |  |  |  | Dad |  | 48
Week 9 |  |  |  |  | Week 19 |  |  |  |  | Week 29 |  |  |  |  |  | Week 9
Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  |  | Person | Winnings | Bet | P/L per Bet
Me |  | 54 |  |  | Me |  | 114 |  |  | Me |  | 174 |  |  |  | Me |  | 54
Stuart |  | 54 |  |  | Stuart |  | 114 |  |  | Stuart |  | 174 |  |  |  | Stuart |  | 54
Dad |  | 54 |  |  | Dad |  | 114 |  |  | Dad |  | 174 |  |  |  | Dad |  | 54
Week 10 |  |  |  |  | Week 20 |  |  |  |  | Week 30 |  |  |  |  |  | Week 10
Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  | Person | Winnings | Bet | P/L per Bet |  |  | Person | Winnings | Bet | P/L per Bet
Me |  | 60 |  |  | Me |  | 120 |  |  | Me |  | 180 |  |  |  | Me |  | 60
Stuart |  | 60 |  |  | Stuart |  | 120 |  |  | Stuart |  | 180 |  |  |  | Stuart |  | 60
Dad |  | 60 |  |  | Dad |  | 120 |  |  | Dad |  | 180 |  |  |  | Dad |  | 60