Thread: Countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tubthumper Tubthumper is offline
external usenet poster
 
Posts: 9
Default Countif

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