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.
Quote:
Originally Posted by 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 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!
|