Countif based on two different columns?

[Garrek]

I have a data set with two columns of data, let's just say A1-A10 and B1-B10. I'm looking to do a countif, to count 1 time only if a value is present in both A and B. For example, if "X" is in A1 and "Y" is in B1, I would want to count this once, but if either A1 or B1 was missing their respective value, it wouldn't.

Sorry for the weird explanation. Basically I'm looking to combine =COUNTIF(A1:A10,"X") and =COUNTIF(B1:B10,"Y"). Is this possible? Does it make sense?

 

[Fluff]

Is this what you mean
=COUNTIFS(A1:A10,"X",B1:B10,"Y")

 

[Garrek]

Is this what you mean
=COUNTIFS(A1:A10,"X",B1:B10,"Y")

Ahh yes, discovered a new useful function! Perfect. Thanks.

 

[Fluff]

Glad to help & thanks for the feedback