COUNTIF

[blah]

I'm trying to using COUNTIF to count the occurences of the string
"2,R04K,606"

Here is my syntax:

=COUNTIF(C12:C28,"2,R04K,606")

Here is the column data:

 

[blah]

26/04/2006
26/04/2006
26/04/2006
26/04/2006
26/04/2006
26/04/2006
26/04/2006
2,R04K,606
26/04/2006
26/04/2006
26/04/2006
26/04/2006
26/04/2006
26/04/2006
26/04/2006


I'm getting a count of 0 with the syntax listed, anyone know what is wrong?

 

[Daveo]

Hi there,

Try this:

=COUNTIF(C12:C28,"*2,R04K,606*")

Cheers - David

 

[Bob Phillips]

Do you have leading or trailing spaces in the data? It works fine for me.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)