SUMPRODUCT

[Castor]

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

 

[Don Guillett]

And the question is?

 

[Dave Peterson]

Check for extra stuff in each of the cells. (Spaces, especially).

Check to see if those 2's are just formatted to show 2 but the actual value is
different?