Countif/sumif/ sum with if statments??
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)
|