Countif problem

  • Thread starter Thread starter David Cleland
  • Start date Start date
D

David Cleland

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
 
use ~? to count ?, and ~~ to count ~.

=COUNTIF(Range,"A~*")
Click to expand...


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 said:
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
Click to expand...
 
LOL...I love you guys! Thanx for making my day, it was a long one, too...LOL
LOL
--
Summer

| Nice to be loved. Purely IT or not!
|
| | >
| >
| > > 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
| >
| >
|
|
 
Back
Top