Countif question

  • Thread starter Thread starter Patrick C. Simonds
  • Start date Start date
P

Patrick C. Simonds

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")
 
Use =COUNTIF(D19:AB19,"On Call*")
where the asterisk (*) is a wild card meaning "and anything else after On
Call"
best wishes
 
Use =COUNTIF(D19:AB19,"On Call*")
where the asterisk (*) is a wild card meaning "and anything else after On
Call"
best wishes
 
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")
Click to expand...

you should be able to use the wildcard *

try this
=COUNTIF(D19:AB19,"On Call*")
 
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")
Click to expand...

you should be able to use the wildcard *

try this
=COUNTIF(D19:AB19,"On Call*")
 
Patrick C. Simonds said:
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")
Click to expand...


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'.
 
Patrick C. Simonds said:
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")
Click to expand...


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'.
 
Back
Top