occurance of string:COUNTIF

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?


"blah" <blah@blah.ca> wrote in message
news:pnp4g.67572$VV4.1291431@ursa-nb00s0.nbnet.nb.ca...
> 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:
>
>

Hi there,

Try this:

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

Cheers - David

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)

"blah" <blah@blah.ca> wrote in message
news:dop4g.67574$VV4.1291810@ursa-nb00s0.nbnet.nb.ca...
> 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?
>
>
> "blah" <blah@blah.ca> wrote in message
> news:pnp4g.67572$VV4.1291431@ursa-nb00s0.nbnet.nb.ca...
> > 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:
> >
> >
>
>