Using LEFT() in COUNTIF

  • Thread starter Thread starter Joe M.
  • Start date Start date
J

Joe M.

I would like to use the formula =(COUNTIF('CM(Sched)'!AQ:AQ,"ACIP")) to count
the number of times "ACIP" appears in column AQ. Sometimes the text is just
ACIP, sometimes it contains other text after i.e. "ACIP123". Therefore I need
to count only if the left 4 charactors in column AQ ="ACIP". I've tried to
add LEFT in my formula somewhere but can't get past syntax errors. Can
someone help?
Thanks,
Joe M.
 
=COUNTIF('CM(Sched)'!AQ:AQ,"ACIP*")


I would like to use the formula =(COUNTIF('CM(Sched)'!AQ:AQ,"ACIP")) to count
the number of times "ACIP" appears in column AQ. Sometimes the text is just
ACIP, sometimes it contains other text after i.e. "ACIP123". Therefore I need
to count only if the left 4 charactors in column AQ ="ACIP". I've tried to
add LEFT in my formula somewhere but can't get past syntax errors. Can
someone help?
Thanks,
Joe M.
Click to expand...
 
Back
Top