Using ? in criteria

[RyanH]

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?

 

[Domenic]

Try...

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

 

[RyanH]

Worked perfectly. Thank you very much.

Try...

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

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