Need Help Gang!!!

[Evagrius Ponticus]

I need help please. I have a column of data and I am trying to use the counfif function to count the accurances of a certain string using a cell reference but I can't get it to work. Here is what I mean


a-01 a-01tx1111
a-02tx21212t
a-03tx1111

Now, assume that the a-01 to the far left is in cell A1, and I am trying to count the occurances of that string in the column above using cell A1 as a reference. here is what I did

=countif(range,left(A1,4)="a-01")

what am I doing wrong guys? I keep getting a zero.

 

[Norie]

Sorry but that doesn't really make much sense.

If you wanted to use COUNTIF with a cell reference it would be more like this.

=COUNTIF(B1:B10, A1)

And since you are only looking for a partial match it might look more like this.

=COUNTIF(B1:B10, "*" & A1 & "*")

 

[Evagrius Ponticus]

haha Norie, my initial post didnt' even make sense to me, but I did what you said and it worked . . . .thanks bud . . .