People
Please glance over my formula below (which BTW I've placed in Cell E10).
As you'll see I'm counting the number of 'yes' in E6:E9 and counting the number of 'yes' and 'no' in the same range. I've bolted on the start of the formula the bits I thought would ensure Cell E10 would appear...