| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count matches within two columns
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count matches within two columns
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! ================================================== === "J.W. Aldridge" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you count data that matches more than one condition? | Excel Worksheet Functions | |||
| count each row for total matches | New Users to Excel | |||
| Compare columns, count matches | Excel Worksheet Functions | |||
| count the # of entries when sum matches the target | Excel Worksheet Functions | |||
| COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions | |||
Linear Mode
