Spreadsheet: 863666d1711076728-trying-to-count-txt-cells-down-a-screen-countif-multiple-columns-totals_a
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Validation Lists
Player ID | Count | Player Code | Decision |  |  |  |  |  |  |  |  |  |  | Decision Selection List |  | Player Code |  | Workings List
Player #1 | 1 | O2 | Yes L2 |  |  |  |  |  |  |  |  |  |  | Yes L2 |  | O2 |  | O2
Player #2 | 2 | O6 | Yes L6 |  |  |  |  |  |  |  |  |  |  | Yes L2(S) |  | S2 |  | O6
Player #3 | 3 | O6 | Yes L6 |  |  |  |  |  |  |  |  |  |  | Yes L3 |  | O3 |  | O6
Player #4 | 4 | O6 | Yes L6 |  |  |  |  |  |  |  |  |  |  | Yes L3(S) |  | S3 |  | O6
Player #5 | 5 | O5 | Out |  |  |  |  |  |  |  |  |  |  | Yes L4 |  | O4 |  | O5
Player #6 | 6 | O6 | Yes L6 |  |  |  |  |  |  |  |  |  |  | Yes L4(S) |  | [NAME] |  | O6
Player #7 | 7 | S2 | Yes L2(S) |  |  |  |  |  |  |  |  |  |  | Yes L5 |  | O5 |  | S2
Player #8 | 8 | S6 | Yes L6(S) |  |  |  |  |  |  |  |  |  |  | Yes L5(S) |  | S5 |  | S6
Player #9 | 9 | O6 | Yes L6 |  |  |  |  |  |  |  |  |  |  | Yes L6 |  | O6 |  | O6
Player #10 | 10 | O6 | Yes L6 |  |  |  |  |  |  |  |  |  |  | Yes L6(S) |  | S6 |  | O6
Player #11 | 11 | O5 | No |  |  |  |  |  |  |  |  |  |  | Injured |  |  |  | O5
Player #12 | 12 | O6 | Yes L6 |  |  |  |  |  |  |  |  |  |  | NE |  |  |  | O6
Player #13 | 13 | S3 | Yes L3(S) |  |  |  | Yes | Yes (xS) | NE | No | Injured | Out |  | No |  |  |  | S3
Player #14 | 14 | S3 | Yes L3(S) |  |  |  |  |  |  |  |  |  |  | Out |  |  |  | S3
Player #15 | 15 | S3 | Yes L3(S) |  |  | L2 |  |  |  |  |  |  |  |  |  |  |  | S3
Player #16 | 16 | O6 | Yes L6 |  |  | L3 |  |  |  |  |  |  |  |  |  |  |  | O6
Player #17 | 17 | O6 | Yes L6 |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  | O6
Player #18 | 18 | S6 | No |  |  | L5 |  |  |  |  |  |  |  | Decisions List |  | O5:O19 |  | S6
Player #19 | 19 | S5 | No |  |  | L6 |  |  |  |  |  |  |  | Level Code |  | Q5:Q14 |  | S5
Player #20 | 20 | S5 | No |  |  | Totals |  |  |  |  |  |  |  |  |  |  |  | S5
Player #21 | 21 | O5 | Yes L5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #22 | 22 | O5 | Yes L5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #23 | 23 | O5 | Yes L5 |  |  | Grand Total |  |  |  |  |  |  |  |  |  |  |  | O5
Player #24 | 24 | O4 | Yes L4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #25 | 25 | O4 | Yes L4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #26 | 26 | S2 | Yes L2(S) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S2
Player #27 | 27 | [NAME] | Yes L4(S) |  | Explanations of Headings |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #28 | 28 | S6 | Yes L6(S) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S6
Player #29 | 29 | O2 | Yes L2 |  | Player ID | Player name |  |  |  |  | Decision Selection List |  |  |  |  |  |  | O2
Player #30 | 30 | S6 | Yes L6(S) |  | Count | No of Players |  |  |  |  | Player Code |  |  |  |  |  |  | S6
Player #31 | 31 | S6 | Injured |  | Player Code | Category (Open or Senior player) |  |  |  |  |  |  |  |  |  |  |  | S6
Player #32 | 32 | S6 | Yes L6(S) |  | Decision | Performance Decision |  |  |  |  |  |  |  |  |  |  |  | S6
Player #33 | 33 | S6 | Yes L6(S) |  |  | made by Coaches |  |  |  |  |  |  |  |  |  |  |  | S6
Player #34 | 34 | S5 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S5
Player #35 | 35 | S6 | Yes L6(S) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S6
Player #36 | 36 | [NAME] | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #37 | 37 | O4 | NE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #38 | 38 | O5 | Injured |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #39 | 39 | O5 | NE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #40 | 40 | O2 | Yes L2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O2
Player #41 | 41 | [NAME] | NE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #42 | 42 | O5 | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #43 | 43 | S5 | NE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S5
Player #44 | 44 | S5 | NE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S5
Player #45 | 45 | O6 | Injured |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O6
Player #46 | 46 | [NAME] | Yes L4(S) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #47 | 47 | [NAME] | NE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #48 | 48 | [NAME] | NE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #49 | 49 | O5 | Yes L5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #50 | 50 | O5 | Yes L5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #51 | 51 | O5 | Yes L5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #52 | 52 | [NAME] | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #53 | 53 | O4 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #54 | 54 | [NAME] | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #55 | 55 | [NAME] | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #56 | 56 | O5 | Yes L5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #57 | 57 | [NAME] | Injured |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #58 | 58 | O4 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #59 | 59 | O5 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #60 | 60 | O5 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #61 | 61 | O4 | Injured |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #62 | 62 | [NAME] | Yes L4(S) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #63 | 63 | O5 | Yes L5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #64 | 64 | O3 | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O3
Player #65 | 65 | O5 | Yes L5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #66 | 66 | S3 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S3
Player #67 | 67 | O5 | Yes L5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #68 | 68 | O4 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #69 | 69 | O4 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #70 | 70 | O4 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #71 | 71 | [NAME] | Injured |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #72 | 72 | O4 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #73 | 73 | [NAME] | NE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #74 | 74 | O4 | Yes L4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #75 | 75 | O5 | NE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #76 | 76 | [NAME] | Injured |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #77 | 77 | S5 | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S5
Player #78 | 78 | O4 | NE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #79 | 79 | O4 | NE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O4
Player #80 | 80 | S5 | Yes L5(S) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S5
Player #81 | 81 | S5 | Yes L5(S) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S5
Player #82 | 82 | [NAME] | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #83 | 83 | S5 | Yes L5(S) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S5
Player #84 | 84 | O5 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O5
Player #85 | 85 | O3 | Yes L3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O3
Player #86 | 86 | S5 | Yes L5(S) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S5
Player #87 | 87 | O2 | Yes L2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O2
Player #88 | 88 | [NAME] | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Player #89 | 89 | S5 | Yes L5(S) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S5