Countif problem

Count A~* instead of A*
the ~ indicates you want the next character to NOT be treated as a wildcard.
use ~? to count ?, and ~~ to count ~.

=COUNTIF(Range,"A~*")

Bob Umlas
Excel MVP
"David Cleland" <davidjcleland@hotmail.com> wrote in message
news:uEuQBRzpFHA.1416@TK2MSFTNGP09.phx.gbl...
> Hi
>
> I have an excel and I want to count letters - one of the things I am
> counting is the number of A* where A* is the actual data.
>
> In countif excel is treating the * as a wildcard and is counting As too -
I
> only want it to count "A*" - any ideas ?
>
> David
>
>

> use ~? to count ?, and ~~ to count ~.
>
> =COUNTIF(Range,"A~*")


Bob, the relief of the speed of you post forces me to proclaim I love
you*... this has been doing my head in all day and I need it for tomorrow

thanks so much


David

in a purely IT kinda way

Nice to be loved. Purely IT or not!

"David Cleland" <davidjcleland@hotmail.com> wrote in message
news:%23XlQ$bzpFHA.3536@TK2MSFTNGP15.phx.gbl...
>
>
> > use ~? to count ?, and ~~ to count ~.
> >
> > =COUNTIF(Range,"A~*")
>
>
> Bob, the relief of the speed of you post forces me to proclaim I love
> you*... this has been doing my head in all day and I need it for
tomorrow
>
> thanks so much
>
>
> David
>
> in a purely IT kinda way
>
>

LOL...I love you guys! Thanx for making my day, it was a long one, too...LOL
LOL
--
Summer

"Bob Umlas" <Excel_Trickster@msn.com> wrote in message
news:OY$N9W1pFHA.712@tk2msftngp13.phx.gbl...
| Nice to be loved. Purely IT or not!
|
| "David Cleland" <davidjcleland@hotmail.com> wrote in message
| news:%23XlQ$bzpFHA.3536@TK2MSFTNGP15.phx.gbl...
| >
| >
| > > use ~? to count ?, and ~~ to count ~.
| > >
| > > =COUNTIF(Range,"A~*")
| >
| >
| > Bob, the relief of the speed of you post forces me to proclaim I love
| > you*... this has been doing my head in all day and I need it for
| tomorrow
| >
| > thanks so much
| >
| >
| > David
| >
| > in a purely IT kinda way
| >
| >
|
|