Following problem:

x 4 4
x 1 2
y 4 3
y 3 2
z 3 3

I am trying to count the number of times a value in column 2 matches the value in column 3, given a value in column 1. I.e. if column1=x, the result should be 1. if column1=y, the result should be 0, etc.

Could you please help solve this problem? I have to apply it to a spreadsheet with thousands of entries..

Thanks!

Hi

One way. assuming your data is in A1:C5. In E1:E3 allocate your values x, y, z. Then in F1: =SUM(IF($B$1:$B$5=$C$1:$C$5,1)*($A$1:$A$5=E1)). CSE & copy down.

"zctpec3" wrote:
Following problem:
x 4 4
x 1 2
y 4 3
y 3 2
z 3 3
I am trying to count the number of times a value in
column 2 matches the value in column 3, given a value
in column 1. I.e. if column1=x, the result should be 1.
if column1=y, the result should be 0, etc.

=SUMPRODUCT(($A$1:$A$1000="x")*($B$1:$B$1000=$C$1: $C$1000))

Of course, you can replace "x" with a reference to a cell with that value.

Have a look at the attached. This is one way.

Great, thanks a lot everyone, this solved my problem!