Help
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.
I am using the IF function to get a YES or NO response .
I am trying to get the number of YES anwsers. I get to to this in mulitple steps but I am wondering if there a cleaner way.
The COUNTA function does not seem to work.
I guess in my IF statement i can make the NOs blank then I can use COUNTA since the NO will be blank
Do anybody know to counta repsonses assuming i leave the NOs as NOs
Thanks
I am trying to get the number of YES anwsers. I get to to this in mulitple steps but I am wondering if there a cleaner way.
The COUNTA function does not seem to work.
I guess in my IF statement i can make the NOs blank then I can use COUNTA since the NO will be blank
Do anybody know to counta repsonses assuming i leave the NOs as NOs
Thanks
Back to top
