Count with multiple criteria / combination

E

Eán

What formula or macro can I use to get the following information?
From two columns of information I need to find out how many times a certain
combination occurs for example:
Text in colums A1:A22 and B1:B22 will be a mixture of "spade", "heart",
"club", "diamond" so I need to find out if what the combinations per row are
i.e:
A1 = heart B1 = spade
A2 = heart B2 = heart
A3 = heart A3 = spade
So:
heart / spade combination = twice
heart / heart combination = once
Help please......
 
D

Domenic

Eán said:
What formula or macro can I use to get the following information?
From two columns of information I need to find out how many times a certain
combination occurs for example:
Text in colums A1:A22 and B1:B22 will be a mixture of "spade", "heart",
"club", "diamond" so I need to find out if what the combinations per row are
i.e:
A1 = heart B1 = spade
A2 = heart B2 = heart
A3 = heart A3 = spade
So:
heart / spade combination = twice
heart / heart combination = once
Help please......
Click to expand...

Let D2 contain heart and E2 contain spade

Let D3 contain heart and E3 contain heart

Then try...

F2, copied down:

=SUMPRODUCT(--($A$1:$A$22=D2),--($B$1:$B$22=E2))
 

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

Count if text meets given criteria 2
Cell Range Split into Multiple Cells 6
Multiple Criteria Sum 8
Problems with the Right & Find functions 14
Creating list from values that meet multiple criteria from other sheet 1
IF FUCTION WITH 2 SETS OF CRITERIA 7
How do I count # of cells with same value other column? 4
having problems with a multiple conditions nesting formula 3

Top