Need Help with Counting Formula

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!