Hello All,
So I am trying to get a:
But wasn't sure how to piece this together....
So I am trying to get a:
- grand total count of Ys by 1 (1 is a RN) ....result should be 3
- grand total count of Ns by 1 (1 is a RN) ...result should be 6
- grand total count of Ys by 2 (2 is a MD)....result should be 1
- grand total count of Ns by 2 (2 is a MD) ...result should be 2
But wasn't sure how to piece this together....
A1 | B2 | C2 | D2 | |
1 for RN, 2 for MD | Q1 (Compliant: Y or N) | Q2 (Compliant: Y or N) | Q3 (Compliant: Y or N) | |
A3 | 1 | N | N | Y |
A4 | 2 | N | Y | N |
A5 | 1 | N | Y | N |
A6 | 1 | Y | N | N |
1 (RN) | 6 N | 3 Y | ||
2 (MD) | 2 N | 1 Y |