With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, December 21, 2012
yogi_Get Count Of Yes And No By Each Player From A Table Of Players And (Yes/No) Status
Google Spreadsheet Post #935
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Dec 21, 2012 user LeslieMc said:(http://productforums.google.com/forum/?zx=vz0n90hy7lti#!category-topic/docs/spreadsheets/q7amw9_Z0ng) 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...
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.