SUMPRODUCT
 

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

SUMPRODUCT
 

And the question is?

--
Don Guillett
SalesAid Software

"Castor" wrote in message
...
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

SUMPRODUCT
 

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?

Castor wrote:

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

--

Dave Peterson