Countif

  • Thread starter Thread starter ML
  • Start date Start date
M

ML

Hi.
I'm doing a spreadsheet for exam results statistics at the school where I
work.
In a column I'm using =COUNTIF(E23:AE23,"A") for the rows of each pupil
where the columns are the subjects.
Trouble is when I use =COUNTIF(E23:AE23,"A*") it counts the A and the A*,
How can I seperate the two?
Thanks
D
 
Since the asterisk (*) is a wildcard, you need to flag it as a literal
asterisk by preceeding it with a tilde (~).

Try this:
=COUNTIF(E23:AE23,"A~*")


Does that help?
***********
Regards,
Ron

XL2003, WinXP
 
Hi.
I'm doing a spreadsheet for exam results statistics at the school where I
work.
In a column I'm using =COUNTIF(E23:AE23,"A") for the rows of each pupil
where the columns are the subjects.
Trouble is when I use =COUNTIF(E23:AE23,"A*") it counts the A and the A*,
How can I seperate the two?
Click to expand...
Use "A~*"
Tilde is an escape character for wildcards in some Excel operations.

Of course you could have subtracted the "A" result from "A*" but as the
* is a wildcard, that would bring in other results like AAA, if such
exist.
 
Back
Top