The CountIf() function is what you are looking for. Here's an example: =COUNTIF(F4:F175,"Yes")
where: F4:F175 is the cell range to look for and "Yes" is the value to be looked in the specified cell range On 10/5/15, Giri Prasad <mgiriprasadma...@gmail.com> wrote: > Dear all, > I want to count the number of "No's and Yes" in a column ranging from > F4 to F175. > Could someone help me out with the function to achieve the task? > Thanks. > > > -- > WITH REGARDS > > GIRIPRASAD > > MOBILE: 9247170000 / 9441133367 > > SKYPE giriprasad.maddina > > "Our greatest glory consists not in never falling, > but in rising every time we fall." > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > -- Best Regards, Zujar... An optimist laughs to forget, whereas a pessimist forgets to laugh! Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..