View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RyanH RyanH is offline
external usenet poster
 
Posts: 586
Default Using ? in criteria

I am trying to use a countifs function to count the ?'s in a column for a
particular category, i.e. countifs(A1:A10,"Workshop",B1:B10,"?"). However,
it looks like the function is picking the ? as a wildcard because it is
giving me a count of all entries with a single character. I have tried
using "?" and referencing it in a cell. Any suggestions?