| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Left vs Left$ function | Excel Discussion (Misc queries) | |||
| COUNTIF(LEFT('SpreadSheet1!A1:A25, 1), "A") | Excel Worksheet Functions | |||
| Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
| My columns run from right to left instead of left to right. Help? | Setting up and Configuration of Excel | |||
| How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) | |||
Linear Mode
