Try...

=COUNTIFS(A1:A10,"Workshop",B1:B10,"~?")

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

In article ,
RyanH wrote:

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?