Try
=COUNTIF(A:A,A1)+COUNTIF(F:F,A1)+COUNTIF(J:J,A1)

--
Jacob


"Lise" wrote:

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