Countif

T

Tubthumper

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
 
D

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 ~
 
R

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.
 
Top