Count

[Guest]

Hi Experts, I have a question.
if column A has letters A, B, C or D multiple and column B has numbers 1, 2
or 3.

Column A Column B
a 1
a 1
a 2
a 2
a 2
a 2
a 1
a 2
a 1
b 2
b 1
b 1
b 2
b 1
b 1
b 1
c 2

I want to count the instances where
column A has A and Column B has 1
column A has A and Column B has 2
column A has A and Column B has 3
column A has B and column B has 1
column A has B and column B has 2
column A has B and column B has 2
column A has B and column B has 3
column A has C and column B has 1
column A has C and column B has 2
column A has C and column B has 3
column A has D and column B has 1
column A has D and column B has 2
and
column A has D and column B has 3

please help me...

 

[Guest]

Have you looked at doing a pivot table. Place Columns A and then B in the
left of the pivot table and then place column B in the middle of the table.
Switch the aggregation to Count and that should do it... if you want more
help with that just reply back...

 

[Guest]

Assume you data is in A2:B100 and A1:B1 are header labels.
Select A1:B100 and do Data=>Filter=>Advanced Filter, select unique in the
lower left and copy to. Then select a range like D1. And click OK. (leave
criteria blank)

in F2
=sumproduct(--($A$2:$A$100=D2),--($B$2:$B$100=E2))

then drag fill down the column.