Need to count if Column A contains definded text and Column B equals defined word

[JBlo]

Good day,

I need help with a formula that would count the instances in Column C, where Column A contains "LH" or "RH" as part of the word, and column B equals "Either".

[Tony Valko]

Maybe this...

=SUM(COUNTIFS(A:A,"*"&{"LH","RH"}&"*",B:B,"Either"))

[JBlo]

Tony this is exactly what I was looking for. Thank you for your timely response.

[JBlo]

The multiple criteria in column A is where I was getting caught up. Can the below be applied to any IF statement when you are trying to identify one of multiple text strings?

*"&{"LH","RH"}&"*"

[Tony Valko]

No, the IF function doesn't accept wildcards which is what the asterisks represent.

Can you post some sample data and tell us what result you expect?

[JBlo]

I don't have a specific example it was more of a general question for future reference. I have marked this thread as solved. Thanks much for your time and assistance.

Jamie