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

  • Thread starter Thread starter xj6rob
  • Start date Start date
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...
 
Try this:

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

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

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for identifying the last entry in a table 2
Counting unique values in multiple columns 4
How to count each of the unique entries in a column? 10
Count If Vlookup Array 3
Unique entries spread over several columns 7
condionally formatting based on another cells formatting? 2
Last entry in a column 6
Repeat Values in Column A, Break and Sum 2

Back
Top