Hello:

I have the following problem:

Column A Column B
A 1
A 2
B 1
B 1
B 2
B 2

I want to count all instances when column A = B and Column B = 1 i.e. the
answer should be 2
I am using the following:

=SUMPRODUCT((A1:A200="B")*(B1:B200=1))

Tks a lot! - Saad