Need Formula for Returning Unique Count from Partial Criteria

[bananney]

[TABLE="width: 335"]
<tbody>[TR]
[TD]
I am trying to get a formula that will return the following result. If column B shows "Out-of-Town" any where in the cell, then I want to count the number of unique employees that are out-of-town at any time during that week. For this particular week there should be 2. The problem I have is that the words "Out-of-Town" are only a portion of the cell and using the wildcard asterick doesn't give the correct answer.


[TABLE="width: 400"]
<tbody>[TR]
[TD]Employee
[/TD]
[TD]Location
[/TD]
[/TR]
[TR]
[TD]135
[/TD]
[TD]Out-of-Town Monday
[/TD]
[/TR]
[TR]
[TD]201
[/TD]
[TD]At Work
[/TD]
[/TR]
[TR]
[TD]344
[/TD]
[TD]At Work
[/TD]
[/TR]
[TR]
[TD]135
[/TD]
[TD]Out-of-Town Friday
[/TD]
[/TR]
[TR]
[TD]344
[/TD]
[TD]Out-of-Town Wednesday
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[nalali]

Use Countifs(B:B,"Out-of-Town*",A:A,"135")

 

[bananney]

Thanks but that is not what I am looking for. I want to know how many employees are out of town this week. I should be able to see that 2 employees are out of town.