Countif

[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

 

[Guest]

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

 

[Wild Bill]

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?

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.

 

[ML]

I knew you guys would have the answer
Thank you!!
D