Countif/sumif/ sum with if statments??

[Sivart]

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)

 

[Jacob Skaria]

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

 

[Sivart]

Maybe this will help explain a littl more

List of names:
a3=adam
a4=betty

b22=adam d22=x
b23=betty d23=(nothing)
b24=adam d24=x
b25=adam d25=(nothing)

b3=the countif that you just mentioned =COUNTIF(B22:B900,A3)

I need for b4 to tell me how many "x" have been placed in d22:d25 for all
the adam's(a3's, if I change adam to amy I still want it to work) in b22:25.

result of b3 is 3. I need for the result of C3 to be 2, the number of x's
for adam.
result of b4 is 1. and c4 should be zero because no "x"'s have been placed
in d22:d25 for betty