A is the count, B is the text to be counted, C is the range. I am wanting to be able to place a formula such as "countif(C1:C10, *B1*)" in cell A1 and drag down. It only needs to contain the B1 text not be exact. I want to avoid having to type in "*:001*", "*:002*" etc. in column A. Columns B & C are both stored as text values.


A B C
1 :001 01:003
3 :002 02:002
1 :003 03:002
1 :004 04:001
0 :005 05:003
1 :006 01:006
0 :007 02:008
1 :008 03:004
0 :009 04:005
0 :010 05:002