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.