COUNTIF coll A has x and Coll B has y
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?
|