|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 16th, 2009, 09:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif question
I need to be able to check the range D19:AB19 for any occurrence of the
phrase On Call. That is easy enough with the formula below so my problem is it could be entered as just On Call or On Call #1 or On Call #4 ect. So what I need is something that will count the occurance of On Call or any phrase containing On Call. =COUNTIF(D19:AB19,"On Call") 
|
|
#2
May 16th, 2009, 09:33 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif question
Hi
You have to use a wildcard. =COUNTIF(D19:AB19,"On Call*") Regards, Per "Patrick C. Simonds" skrev i meddelelsen ... I need to be able to check the range D19:AB19 for any occurrence of the phrase On Call. That is easy enough with the formula below so my problem is it could be entered as just On Call or On Call #1 or On Call #4 ect. So what I need is something that will count the occurance of On Call or any phrase containing On Call. =COUNTIF(D19:AB19,"On Call")
|
|
#3
May 16th, 2009, 09:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif question
Use =COUNTIF(D19:AB19,"On Call*")
where the asterisk (*) is a wild card meaning "and anything else after On Call" best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Patrick C. Simonds" wrote in message ... I need to be able to check the range D19:AB19 for any occurrence of the phrase On Call. That is easy enough with the formula below so my problem is it could be entered as just On Call or On Call #1 or On Call #4 ect. So what I need is something that will count the occurance of On Call or any phrase containing On Call. =COUNTIF(D19:AB19,"On Call")
|
|
#4
May 16th, 2009, 09:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif question
"Patrick C. Simonds" wrote in
: I need to be able to check the range D19:AB19 for any occurrence of the phrase On Call. That is easy enough with the formula below so my problem is it could be entered as just On Call or On Call #1 or On Call #4 ect. So what I need is something that will count the occurance of On Call or any phrase containing On Call. =COUNTIF(D19:AB19,"On Call") you should be able to use the wildcard * try this =COUNTIF(D19:AB19,"On Call*")
|
|
#5
May 16th, 2009, 09:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif question
In article ,
"Patrick C. Simonds" wrote: I need to be able to check the range D19:AB19 for any occurrence of the phrase On Call. That is easy enough with the formula below so my problem is it could be entered as just On Call or On Call #1 or On Call #4 ect. So what I need is something that will count the occurance of On Call or any phrase containing On Call. =COUNTIF(D19:AB19,"On Call") If 'On Call' occurs at the beginning of the text string, try... =COUNTIF(D19:AB19,"On Call*") or =COUNTIF(D19:AB19,A2&"*") ....where A2 contains 'On Call'. If 'On Call' can occur anywhere within the text string, try... =COUNTIF(D19:AB19,"*On Call*") or =COUNTIF(D19:AB19,"*"&A2&"*") ....where, again, A2 contains 'On Call'. -- Domenic http://www.xl-central.com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
