Count matches within two columns

J

J.W. Aldridge

On sheet 2....I have a lookup name in cell A1, and a lookup time
(hour) in B1.

On sheet 1, I have a list of names in A:A, and a list of (hours) in
C:C.

How do I count the number of matches between the two?



AMY 12
AMY 15
BRUCE 12
BRUCE 22
AMY 12
AMY 12
AMY 12
BRUCE 33
AMY 23


So the formula would look up how many AMY are in the same row as 12
which equals 4.

Thanx
 
R

RagDyeR

Try this formula in *either* Sheet1 or Sheet2:

=SUMPRODUCT((Sheet1!A1:A9=Sheet2!A1)*(Sheet1!B1:B9=Sheet2!B1))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


On sheet 2....I have a lookup name in cell A1, and a lookup time
(hour) in B1.

On sheet 1, I have a list of names in A:A, and a list of (hours) in
C:C.

How do I count the number of matches between the two?



AMY 12
AMY 15
BRUCE 12
BRUCE 22
AMY 12
AMY 12
AMY 12
BRUCE 33
AMY 23


So the formula would look up how many AMY are in the same row as 12
which equals 4.

Thanx
 

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

Sum up 2 or more columns under same SUMIF criteria 2
Keep total of cells in a cell after deleting source data 8
Insert Calculated Field (wrong Qty*Price = wrong Amount) 8
Insert Index into a Table 1
Count number of text rows??? 3
Help!! find two number recurring numbers in row?? 1
How do I count the number of blank cells 0
Help showing active months between two dates 5

Top