View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default 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")