Hi,

I've got this formula

=IF('Products and tests'!D5=Sheet1!A2,1,0)+OR(IF('Products and tests'!E5=Sheet1!A2,1,0))+OR(IF('Products and tests'!F5=Sheet1!A2,1,0))+OR(IF('Products and tests'!G5=Sheet1!A2,1,0))+OR(IF('Products and tests'!H5=Sheet1!A2,1,0))

It works fine but I want to apply it to multiple colums but all referencing the same colums just different rows.

I.E.

=IF('Products and tests'!D6=Sheet1!A2,1,0)+OR(IF('Products and tests'!E6=Sheet1!A2,1,0))+OR(IF('Products and tests'!F6=Sheet1!A2,1,0))+OR(IF('Products and tests'!G6=Sheet1!A2,1,0))+OR(IF('Products and tests'!H6=Sheet1!A2,1,0))

At the moment I'm changint the D6, E6 etc manually. Is there a faster way?

Thanks,

trio