Countif

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ML - 18 Aug 2007 17:12 GMT

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

Reply to this Message

Ron Coderre - 18 Aug 2007 17:20 GMT

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
[quoted text clipped - 5 lines]
> Thanks
> D

Reply to this Message

Wild Bill - 18 Aug 2007 17:31 GMT

>Hi.
>I'm doing a spreadsheet for exam results statistics at the school where I
[quoted text clipped - 3 lines]
>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.

Reply to this Message

ML - 19 Aug 2007 09:20 GMT

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

>>Hi.
>>I'm doing a spreadsheet for exam results statistics at the school where I
[quoted text clipped - 9 lines]
> * is a wildcard, that would bring in other results like AAA, if such
> exist.

Reply to this Message

Rate this thread: