View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sivart Sivart is offline
external usenet poster
 
Posts: 3
Default 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)