Simple COUNTIF function help

[zctpec3]

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 th
value in column 3, given a value in column 1. I.e. if column1=x, th
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
spreadsheet with thousands of entries..

Thanks

 

[Kevin@Radstock]

Hi

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

 

[joeu2004]

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.

 

[zctpec3]

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

Great, thanks a lot everyone, this solved my problem

+-------------------------------------------------------------------
+-------------------------------------------------------------------