Spreadsheet: 725623d1616772035-how-to-use-sumproduct-countif-to-count-duplicate-numbers-as-one-lotto-test-002
Sheet: Sheet1

 |  |  |  | Recreation Lotto 10/49 Pool |  |  |  |  |  | [NAME] Number: AGD-000000-00
 |  |  |  | We wish to thank all who participated in the fundraiser.
 |  |  |  | START DATE: February 13th 2021
 |  |  |  | Prize Amount = $500.00
 |  |  |  | GOOD LUCK!
 |  |  |  | Draw Date | [NAME] |  |  |  |  |  |  | RULES
 |  |  |  |  | No 1 | No 2 | No 3 | No 4 | No 5 | No 6 | B
 |  |  |  | 2021-04-03 00:00:00 | 3 | 6 | 7 | 10 | 19 | 21 | 32 | As numbers are drawn for lotto 6/49, your numbers will be removed from your list of numbers.
 |  |  |  | 2021-04-07 00:00:00 | 7 | 8 | 9 | 11 | 12 | 27 | 35
 |  |  |  | 2021-04-10 00:00:00 | 2 | 17 | 19 | 22 | 36 | 40 | 44
 |  |  |  | 2021-04-14 00:00:00
 |  |  |  | 2021-04-18 00:00:00 |  |  |  |  |  |  |  | The first person with all their numbers drawn will win the amount indicated, which is 50% of the total.
 |  |  |  | 2021-04-22 00:00:00
 |  |  |  | 2021-04-26 00:00:00
 |  |  |  | 2021-04-30 00:00:00
 |  |  |  | 2021-05-04 00:00:00 |  |  |  |  |  |  |  | In the event of a tie with 2 or more people, they will share the prize amount.
 |  |  |  | 2021-05-08 00:00:00
 |  |  |  | 2021-05-12 00:00:00
 |  |  |  | Members Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Subtotal
 |  |  |  | Person 1 | 1 | 7 | 8 | 13 | 16 | 27 | 29 | 34 | 38 | 44
 |  |  |  | Person 2 | 3 | 6 | 7 | 8 | 9 | 10 | 11 | 19 | 21 | 32
 |  |  |  | Person 3 | 2 | 7 | 11 | 12 | 21 | 22 | 26 | 27 | 35 | 44
 |  |  |  | Person 4 | 3 | 8 | 12 | 17 | 23 | 28 | 31 | 36 | 46 | 48
 |  |  |  | Person 5 | 1 | 7 | 18 | 21 | 26 | 30 | 33 | 36 | 42 | 49
 |  |  |  | Person 6 | 9 | 11 | 17 | 18 | 23 | 27 | 31 | 33 | 38 | 41
 |  |  |  | Person 7 | 3 | 8 | 16 | 20 | 21 | 23 | 26 | 32 | 37 | 49
 |  |  |  | Person 8 | 1 | 6 | 11 | 17 | 20 | 26 | 30 | 32 | 40 | 49
 |  |  |  | Person 9 | 1 | 6 | 7 | 8 | 12 | 16 | 17 | 19 | 21 | 23
 |  |  |  | Person 10 | 2 | 10 | 14 | 20 | 21 | 24 | 33 | 40 | 47 | 49
 |  |  |  | Person 11 | 2 | 11 | 17 | 23 | 26 | 27 | 31 | 33 | 38 | 39
 |  |  |  | Person 12 | 3 | 7 | 11 | 16 | 19 | 27 | 31 | 33 | 39 | 46
 |  |  |  | Person 13 | 3 | 5 | 6 | 13 | 20 | 26 | 30 | 33 | 40 | 48
 |  |  |  | Person 14 | 2 | 5 | 6 | 8 | 13 | 19 | 20 | 29 | 31 | 33
 |  |  |  | Person 15 | 3 | 6 | 9 | 11 | 21 | 30 | 31 | 37 | 40 | 47
 |  |  |  | Person 16 | 3 | 6 | 7 | 12 | 18 | 28 | 30 | 36 | 43 | 47
 |  |  |  | Person 17 | 3 | 7 | 21 | 23 | 26 | 28 | 29 | 34 | 40 | 48
 |  |  |  | Person 18 | 2 | 8 | 9 | 17 | 20 | 22 | 26 | 31 | 36 | 49
 |  |  |  | Person 19 | 8 | 9 | 12 | 13 | 16 | 18 | 41 | 46 | 47 | 48
 |  |  |  | Person 20 | 3 | 4 | 11 | 13 | 20 | 21 | 23 | 24 | 33 | 47
 |  |  |  | Person 21 | 3 | 9 | 11 | 16 | 23 | 27 | 33 | 36 | 43 | 46
 |  |  |  | Person 22 | 4 | 9 | 11 | 16 | 20 | 23 | 29 | 33 | 38 | 43
 |  |  |  | Person 23 | 2 | 5 | 6 | 10 | 12 | 28 | 42 | 46 | 47 | 49
 |  |  |  | Person 24 | 7 | 13 | 16 | 18 | 21 | 29 | 31 | 37 | 41 | 46
 |  |  |  | Person 25 | 4 | 7 | 13 | 19 | 24 | 29 | 33 | 36 | 44 | 47
 |  |  |  | Person 26 | 8 | 10 | 18 | 22 | 26 | 28 | 33 | 40 | 43 | 49
 |  |  |  | Person 27 | 2 | 3 | 7 | 12 | 14 | 17 | 23 | 29 | 39 | 49
 |  |  |  | Person 28 | 3 | 4 | 6 | 7 | 11 | 19 | 23 | 26 | 33 | 44
 |  |  |  | Person 29 | 2 | 3 | 4 | 6 | 11 | 21 | 22 | 25 | 26 | 27
 |  |  |  | Person 30 | 2 | 4 | 6 | 9 | 10 | 17 | 24 | 30 | 46 | 49
 |  |  |  | Person 31 | 1 | 7 | 11 | 12 | 14 | 19 | 22 | 29 | 34 | 46
 |  |  |  | Person 32 | 2 | 4 | 6 | 8 | 10 | 13 | 21 | 27 | 39 | 41
 |  |  |  | Person 33 | 2 | 3 | 7 | 12 | 18 | 27 | 29 | 36 | 39 | 46
 |  |  |  | Person 34 | 1 | 3 | 7 | 11 | 13 | 26 | 29 | 37 | 39 | 43
 |  |  |  | Person 35 | 1 | 4 | 7 | 12 | 13 | 22 | 25 | 29 | 38 | 44
 |  |  |  | Person 36 | 2 | 4 | 7 | 10 | 13 | 19 | 21 | 22 | 26 | 43
 |  |  |  | Person 37 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 11 | 28 | 29
 |  |  |  | Person 38 | 3 | 6 | 17 | 18 | 28 | 31 | 36 | 39 | 46 | 49
 |  |  |  | Person 39 | 2 | 3 | 5 | 6 | 16 | 17 | 16 | 18 | 47 | 49
 |  |  |  | Person 40 | 2 | 7 | 11 | 16 | 20 | 27 | 28 | 30 | 38 | 49
 |  |  |  | Person 41 | 3 | 7 | 9 | 16 | 17 | 19 | 33 | 34 | 36 | 46
 |  |  |  | Person 42 | 7 | 11 | 15 | 16 | 19 | 22 | 28 | 32 | 37 | 46
 |  |  |  | Person 43 | 3 | 5 | 7 | 16 | 17 | 20 | 24 | 29 | 30 | 44
 |  |  |  | Person 44 | 1 | 3 | 7 | 14 | 20 | 23 | 28 | 32 | 36 | 47
 |  |  |  | Person 45 | 1 | 6 | 17 | 20 | 23 | 24 | 36 | 37 | 45 | 48
 |  |  |  | Person 46 | 2 | 7 | 12 | 14 | 17 | 23 | 32 | 37 | 41 | 43
 |  |  |  | Person 47 | 2 | 5 | 13 | 16 | 22 | 29 | 35 | 37 | 42 | 48
 |  |  |  | Person 48 | 2 | 4 | 6 | 10 | 15 | 18 | 23 | 33 | 39 | 43
 |  |  |  | Person 49 | 2 | 4 | 5 | 8 | 9 | 10 | 12 | 16 | 29 | 49
 |  |  |  | Person 50 | 8 | 11 | 12 | 14 | 22 | 24 | 30 | 36 | 44 | 48