INDEX and Match with Sumifs

[Gcsingh90]

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.

 

[Joe4]

Duplicate to: Sumifs+Index/Match+Lookup

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.