In a cell I have a line of ticks, how do I count them?

--
Cheers

Stephen

Try this:-

=COUNTIF(A1:A100,"="&CHAR(252))

Mike

"Stephen Doyle" wrote:

> In a cell I have a line of ticks, how do I count them?
>
> --
> Cheers
>
> Stephen
>
>
>
>

depends upon what drives the tick. For instance I use a with a font of
Marlett, so I just need

=COUNTIF(rng,"a")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Stephen Doyle" <(E-Mail Removed)> wrote in message
news:OBK$(E-Mail Removed)...
> In a cell I have a line of ticks, how do I count them?
>
> --
> Cheers
>
> Stephen
>
>
>

Or any of these:-

Character to Type Font to Use
a Marlett
a Webdings
b Marlett
C Erilogo
P Wingdings 2
Alt+129 Wingdings
Alt+0214 Symbol
Alt+0252 Wingdings

Mike


"Bob Phillips" wrote:

> depends upon what drives the tick. For instance I use a with a font of
> Marlett, so I just need
>
> =COUNTIF(rng,"a")
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "Stephen Doyle" <(E-Mail Removed)> wrote in message
> news:OBK$(E-Mail Removed)...
> > In a cell I have a line of ticks, how do I count them?
> >
> > --
> > Cheers
> >
> > Stephen
> >
> >
> >
>
>
>

"Mike H" <(E-Mail Removed)> wrote in message
news:CED38B03-EF81-4B32-BF10-(E-Mail Removed)...
> Or any of these:-
>
> Character to Type Font to Use
> a Marlett
> a Webdings
> b Marlett
> C Erilogo
> P Wingdings 2
> Alt+129 Wingdings
> Alt+0214 Symbol
> Alt+0252 Wingdings
>
> Mike
>
>
> "Bob Phillips" wrote:
>
> > depends upon what drives the tick. For instance I use a with a font of
> > Marlett, so I just need
> >
> > =COUNTIF(rng,"a")
> >
> > --
> > HTH
> >
> > Bob
> >
> > (there's no email, no snail mail, but somewhere should be gmail in my
addy)

I ended up using =LEN()
Works a treat

Cheers
Stephen