Spreadsheet: 37029d1234970314-count-if-for-one-column-if-value-matches-in-different-column-count-1-2-3-and-yes
Sheet: Sheet1

 |  |  |  |  |  |  | # Yes |  |  |  |  |  |  |  |  |  |  |  | 1 Yes | 2 Yes | 3 Yes
 |  |  |  |  |  | 1's | 8 |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  | 2's | 14 |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  | 3's | 12 |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0