Countif

[Guest]

Hi,
I have a list of student exam grades that include A and A*. However, I
can't use countif to calculate the number of A* (returns the total of A and
A*) trying to countif the * doesn't work either (* is used as a wildcard and
returns everything!). I've tried using single quotation marks but to no
avail!

Any suggestions?

Thanks

 

[Roger Govier]

Hi

Try
=COUNTIF(A1:A100,"=A~*")

 

[Guest]

=COUNTIF(A1:A100,"A~*")

 

[Dave Peterson]

Just to add...

* and ? are wild cards.

To find them (edit|Find or =sumif(), =countif(), you use a ~ to tell excel that
you want to treat the next character as that character--not the wild card.

Use ~* to find/replace *
~? to find/replace ?
~~ to find/replace ~

 

[Roger Govier]

Hi Dave

I guess I was being too darned lazy again with my response.
Thanks for providing the OP with the detailed reason why the tilde ~
makes it work.