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 ~



Tubthumper wrote:

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

--

Dave Peterson