Countif problem

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:%[email protected]...
>
>
> > 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" <[email protected]> wrote in message
news:[email protected]...
| Nice to be loved. Purely IT or not!
|
| "David Cleland" <[email protected]> wrote in message
| news:%[email protected]...
| >
| >
| > > 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
| >
| >
|
|