Table 2 | ||||
Month | Status | Ram | K | Chetan |
Jan | Yes | 2 | 2 | 1 |
Jan | No | 0 | 1 | 1 |
Jan | N/A | 3 | 2 | 3 |
Feb | Yes | 2 | 1 | 1 |
Feb | No | 1 | 2 | 1 |
Feb | N/A | 0 | 0 | 1 |
EXPECTED OUTPUT FROM TABLE 2
Table 3 | ||||
Month | Name | Yes+No | Yes | % |
Jan | Ram | 2 | 2 | |
Jan | K | 3 | 2 | |
Jan | Chetan | 2 | 1 | |
Feb | Ram | 3 | 2 | |
Feb | K | 3 | 1 | |
Feb | Chetan | 2 | 1 |
I am trying to count the sum of yes+no in table from table per person when the criteria of month and name matches. I tried to use sumif. Kindly help.