## Friday, December 21, 2012

### yogi_Get Count Of Yes And No By Each Player From A Table Of Players And (Yes/No) Status

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 21, 2012
CountIF? SumIF? SumProduct? I don't know!
Hi All,

I am trying to do something that I am sure is fairly easy, but I just can't seem to make it work.

I would like to do a "count if only if" scenario... allow me to explain...

Example Sheet

A                        B
Bob                   Yes
Sue                   Yes
Bob                   No
Bob                   Yes
Dan                   No
Amy                  No

So what I want to know is, how many times "Bob" returned the result "Yes" (in this case 2 out of his 3). I know this is simple, and the formula I know to use in Excel doesn't work in google.

Any help would be much appreciated.

Thanks!
------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem