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?

Using ? in criteria
 

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?

Using ? in criteria
 

Worked perfectly. Thank you very much.

"Domenic" wrote:

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?