Using LEFT() in COUNTIF
 

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.

Using LEFT() in COUNTIF
 

=sumproduct((left(a2;a22,4)="acip")*1)

"Joe M." wrote in message
...
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.

Using LEFT() in COUNTIF
 

=COUNTIF('CM(Sched)'!AQ:AQ,"ACIP*")



Joe M. wrote:

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.

--

Dave Peterson