One way:

=SUMPRODUCT(--(A1:A100="x"),--(B1:B100="y"))


If you're using XL07 or XL08:

=COUNTIFS(A:A,"x",B:B,"y")

In article ,
jimd wrote:

I can use the countif to check for coll. A having "x" =COUNTIF( A:A,"x") I
get 3. but I need to count how many rows also have "Y" in B
A B
x y
z y
x y
x k

in this case, I should get a answer of 2. Any suggestions?