Spreadsheet: 723848d1615916820-how-to-count-how-many-cells-have-been-conditionally-formatted-lotto-bingo
Sheet: Players numbers

Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Correct # | Date | 1 | 2 | 3 | 4 | 5 | 6
[NAME] | 9 | 17 | 21 | 23 | 25 | 26 | 31 | 39 | 49 | 53 |  | 2021-03-13 00:00:00 | 6 | 8 | 11 | 17 | 29 | 44
[NAME] | 2 | 7 | 13 | 14 | 17 | 18 | 19 | 33 | 46 | 53 |  | 2021-03-20 00:00:00
[NAME] | 11 | 16 | 19 | 20 | 23 | 24 | 25 | 31 | 33 | 38 |  | 2021-03-27 00:00:00
[NAME] | 4 | 8 | 21 | 28 | 34 | 36 | 38 | 40 | 44 | 59 |  | 2021-04-03 00:00:00
Teresa | 2 | 7 | 9 | 13 | 18 | 23 | 33 | 36 | 46 | 52 |  | 2021-04-10 00:00:00
[NAME] | 2 | 12 | 14 | 15 | 20 | 28 | 30 | 47 | 54 | 59 |  | 2021-04-17 00:00:00
[NAME] | 7 | 14 | 21 | 28 | 32 | 36 | 44 | 48 | 53 | 58 |  | 2021-04-24 00:00:00
[NAME] | 8 | 15 | 17 | 25 | 36 | 41 | 45 | 46 | 54 | 58 |  | 2021-05-01 00:00:00
[NAME] | 3 | 7 | 8 | 13 | 16 | 29 | 31 | 32 | 45 | 50 |  | 2021-05-08 00:00:00
[NAME] | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 |  | 2021-05-15 00:00:00
Mandy | 3 | 9 | 13 | 19 | 25 | 33 | 38 | 44 | 52 | 55 |  | 2021-05-22 00:00:00
[NAME] | 2 | 6 | 13 | 16 | 22 | 27 | 33 | 35 | 44 | 46 |  | 2021-05-29 00:00:00
Carol | 3 | 7 | 10 | 15 | 18 | 25 | 28 | 35 | 40 | 55 |  | 2021-06-05 00:00:00
[NAME] | 1 | 9 | 11 | 16 | 24 | 35 | 36 | 44 | 49 | 50 |  | 2021-06-12 00:00:00
Stee | 2 | 4 | 10 | 14 | 17 | 28 | 29 | 36 | 38 | 40 |  | 2021-06-19 00:00:00
Becky | 2 | 7 | 12 | 16 | 28 | 32 | 42 | 44 | 48 | 52 |  | 2021-06-26 00:00:00
Amanda | 1 | 2 | 7 | 8 | 10 | 11 | 29 | 36 | 43 | 57 |  | 2021-07-03 00:00:00
Kristina | 4 | 8 | 9 | 11 | 19 | 21 | 26 | 39 | 42 | 50 |  | 2021-07-10 00:00:00
Sophie | 2 | 6 | 13 | 21 | 22 | 24 | 30 | 31 | 39 | 42 |  | 2021-07-17 00:00:00
Jen H | 5 | 8 | 10 | 11 | 14 | 15 | 26 | 27 | 31 | 59 |  | 2021-07-24 00:00:00
Helen | 1 | 9 | 11 | 18 | 19 | 29 | 38 | 48 | 52 | 57 |  | 2021-07-31 00:00:00
[NAME] | 3 | 6 | 12 | 14 | 22 | 23 | 24 | 27 | 34 | 37 |  | 2021-08-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-08-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-08-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-08-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-09-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-09-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-09-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-09-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-10-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-10-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-10-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-10-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-10-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-11-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-11-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-11-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-11-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-12-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-12-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-12-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2021-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2022-01-08 00:00:00