COUNTIF

B

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:
 
B

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?
 
B

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)
 
Top