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
 
Top