countif (I think)
 

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

--
Cheers

Stephen

countif (I think)
 

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

countif (I think)
 

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" wrote in message
...
In a cell I have a line of ticks, how do I count them?

--
Cheers

Stephen

countif (I think)
 

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" wrote in message
...
In a cell I have a line of ticks, how do I count them?

--
Cheers

Stephen

countif (I think)
 

"Mike H" wrote in message
...
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