Spreadsheet: 838070d1690668633-need-pattern-counting-formulas-example-of-correct-and-incorrect-count
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | example of correct / true count for pattern a |  |  |  |  |  |  |  |  |  |  |  |  |  | example of incorrect /false count for pattern a (formula must not count this way)
 |  |  |  |  |  | <<< 4s are allowed in any column in this row except in cell K8  (green cell) | 4 | 9 | 6 | 6 |  |  |  |  |  |  |  |  |  | <<< 4s are allowed in any column in this row except in cell X8  (green cell) | 4 | 9 | 6 | 6
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 7 | 5 | 3 | 7 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 7 | 5 | 4 | 7
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 3 | 8 | 3 | 3 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 3 | 4 | 3 | 3
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 6 | 7 | 7 | 6 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 6 | 7 | 7 | 4
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 1 | 9 | 6 | 1 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 1 | 4 | 6 | 1
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 8 | 7 | 6 | 8 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 4 | 7 | 6 | 4
 |  |  |  |  |  | <<< 4s are allowed in any column in this row | 7 | 4 | 3 | 4 |  |  |  |  |  |  |  |  |  | <<< 4s are allowed in any column in this row | 7 | 4 | 3 | 4
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 8 | 7 | 7 | 8 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 4 | 7 | 7 | 8
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 7 | 3 | 0 | 7 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 7 | 4 | 0 | 7
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 8 | 1 | 8 | 8 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 4 | 1 | 4 | 4
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 8 | 1 | 8 | 8 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 8 | 4 | 8 | 8
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 5 | 3 | 9 | 5 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 5 | 3 | 4 | 5
 |  |  |  |  |  | <<< 4s are allowed in any column in this row | 4 | 2 | 5 | 4 |  |  |  |  |  |  |  |  |  | <<< 4s are allowed in any column in this row | 4 | 2 | 5 | 4
 |  |  |  |  |  |  |  |  |  | example of correct / true count for pattern b |  |  |  |  |  |  |  |  |  |  |  |  |  | example of incorrect / false count for pattern b (formula must not count this way)
 |  |  |  |  |  | <<< 4s are allowed in any column in this row | 4 | 9 | 6 | 4 |  |  |  |  |  |  |  |  |  | <<< 4s are allowed in any column in this row | 4 | 9 | 6 | 4
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 7 | 5 | 3 | 7 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 7 | 5 | 4 | 7
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 3 | 8 | 3 | 3 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 3 | 4 | 3 | 3
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 6 | 7 | 7 | 6 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 6 | 7 | 7 | 4
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 1 | 9 | 6 | 1 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 1 | 4 | 6 | 1
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 8 | 7 | 6 | 8 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 4 | 7 | 6 | 4
 |  |  |  |  |  | <<< 4s are allowed in any column in this row | 7 | 4 | 3 | 4 |  |  |  |  |  |  |  |  |  | <<< 4s are allowed in any column in this row | 7 | 4 | 3 | 4
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 8 | 7 | 7 | 8 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 4 | 7 | 7 | 8
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 7 | 3 | 0 | 7 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 7 | 4 | 0 | 7
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 8 | 1 | 8 | 8 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 4 | 1 | 4 | 4
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 8 | 1 | 8 | 8 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 8 | 4 | 8 | 8
 |  |  |  |  |  | <<< 4s are not allowed in any columns in this row | 5 | 3 | 9 | 5 |  |  |  |  |  |  |  |  |  | <<< 4s are not allowed in any columns in this row (therefore this count is incorrect) | 5 | 3 | 4 | 5
 |  |  |  |  |  | <<< 4s are allowed in any column in this row | 4 | 2 | 5 | 4 |  |  |  |  |  |  |  |  |  | <<< 4s are allowed in any column in this row | 4 | 2 | 5 | 4