Apply this formula in in C3. Replace namelist with the actual name.

=COUNTIF(namelist,A3)

OR

=COUNTIF(B22:B900,A3)


If this post helps click Yes
---------------
Jacob Skaria


"Sivart" wrote:

Hi,

I have A3:A18 populated with names. In B22:B900 a name listed in A3:A18 will
be put there to "assign" it to them. When they have completed it and "x" is
put in column D on that row.

I need for C3:C18 to tell me how many "x"'s the corresponding name in A has
from B22:B900. Also the name range is likely to change (adding new names or
deleting rows)