Hi everyone

I have a list of names in column a - I then have data in various other
columns which is copied from other worksheets (Columns B, F and J are names)
I want to sum how many time a name in column a is listed in the others so
have entered as:

=SUMPRODUCT(($B$2:$B$500=A2)*($F$2:$F$500=A2)*($J$ 2:$J$500=A2))

But this is not calculating correctly - can someone pls advise what step I'm
missing??
--
Thanks as always

Lise