Using LEFT() in COUNTIF

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.
 
D

Dave Peterson

=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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting cells containing formulas with blank results 3
SUMPRODUCT problem 6
COUNTIF on result of formula 4
max limit to characters in COUNTIF function? 2
Using a sub string in a COUNTIF 2
Selecting specific cells in a column using countif 1
Ignore blank celss in left function 2
Countif - How do I count the number of job titles occurring in a l 3

Top