Counting entries in column C, based on entries in column A

X

xj6rob

I would like to count the # of entries of a value in column C, grouped
by values in column A.

Binder Note Category
AA01 abc 2
AA01 ccc 2
AA01 abc 2
AA01 ddd 3
AA22 aaa 1
AA22 ccc 2

Need to find the # of Category 2's , for every Binder #

Do not have the nested IF's I have tried available at the moment, but I
am getting close...
 
T

T. Valko

Try this:

E1 = some binder code like AA01
E2 = some category number like 2

=SUMPRODUCT(--(A2:A7=E1),--(C2:C7=E2))

Biff
 
Top