Another IF function problem

Hi

I have a table of 3000 individuals who have all valued 13 of 45 products. I need a way of assigning whether an individual gave product 41 a negative value.

So if individual 1 valued product 41 as negative I need a a way of placing a 1 next to all the procuts they valued, and if person 2 then valued 41 as positive I need to assign a 0 to all the procts they valued.

Have been trying IF functions but not sure on exactly how to do this.

Thanks in advance

JAmes

Hello,

maybe

=IF(SUMPRODUCT(--($A$2:$A$40=A2),--($B$2:$B$40=41),--($C$2:$C$40<0)),1,0)

Adjust ranges to suit and copy down.

try
=SUMPRODUCT(--($A$2:$A$40=A2),--($B$2:$B$40=41),--($C$2:$C$40<0)) dragged down adjust ranges to suit
daang slow typing again!