 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006Counting "Question Marks"
Hi all, is there a simple function that will allow me to count the number of "?" in a column of data? I have a longish column that contains only "y", "n",blanks, or "?". I can use COUNTIF functions to count the number of "y" and "n", COUNTBLANK to count the number of blank cells, but if I enter a COUNTIF using "?", it returns a count of all cells containing data. Help please! Regards, Robin =COUNTIF(A:A,"~?")  SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > Hi all, is there a simple function that will allow me to count the number of > "?" in a column of data? I have a longish column that contains only "y", > "n",blanks, or "?". I can use COUNTIF functions to count the number of "y" > and "n", COUNTBLANK to count the number of blank cells, but if I enter a > COUNTIF using "?", it returns a count of all cells containing data. Help > please! Regards, Robin Many thanks Bob! > =COUNTIF(A:A,"~?") > [quoted text clipped - 6 lines] >> COUNTIF using "?", it returns a count of all cells containing data. Help >> please! Regards, Robin Hi Bob, What does "~" do here? Thankyou Shail > =COUNTIF(A:A,"~?") > [quoted text clipped - 12 lines] > > COUNTIF using "?", it returns a count of all cells containing data. Help > > please! Regards, Robin It is an escape character, it tells Excel not to treat the following character as a special character (? is the single wildcard character) but as a normal ASCII character. SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > Hi Bob, > [quoted text clipped - 20 lines] > > > COUNTIF using "?", it returns a count of all cells containing data. Help > > > please! Regards, Robin Thankyou Bob, for sharing the knowledge. Shail > It is an escape character, it tells Excel not to treat the following > character as a special character (? is the single wildcard character) but as [quoted text clipped - 36 lines] > Help > > > > please! Regards, Robin |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.