Need Help with Counting Formula

[benwahchang]

Please see attached file. Looking to count the number of Yes and No for each name. The order could change where "Bob" may not all be grouped together. Let me know if you need more information. If Bob's name is in column B, count the number of Yes only associated with his name. Same for the number of No.

Thanks!

[Jonmo1]

If you do the following..

1. Put "Yes" and "No" in B20 and C20 instead of just Y and N
2. Remove all the extra spaces in A1:B15 (example B1 = "Bob " <-notice extra space at the end)

Then in B20 filled down/right to C21
=COUNTIFS($A$1:$A$15,B$19,$B$1:$B$15,$A20)