Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count or Match Help Please
Good evening,
I have a date in cell D15 and six seperate numbers in cells E14:J14. I have a table in cells B24:M1000, with a date in column D and the six seperate numbers in columns E:J. I would like a formula in cell K15 that finds the date in cell D15 in the table B24:M1000 in column D and counts how many of the numbers in cells E14:J14 match the numbers in the table in column E:J for that specific date please. I am not sure whether to use count or match. Any help will be appreciated. Thanks in advance, Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count or Match Help Please
On Jul 11, 6:08*pm, Paul Black wrote:
Good evening, I have a date in cell D15 and six seperate numbers in cells E14:J14. I have a table in cells B24:M1000, with a date in column D and the six seperate numbers in columns E:J. I would like a formula in cell K15 that finds the date in cell D15 in the table B24:M1000 in column D and counts how many of the numbers in cells E14:J14 match the numbers in the table in column E:J for that specific date please. I am not sure whether to use count or match. Any help will be appreciated. Thanks in advance, Paul Have a look in the help index for COUNTIF |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count or Match Help Please
On Jul 12, 1:54*pm, Don Guillett wrote:
On Jul 11, 6:08*pm, Paul Black wrote: Good evening, I have a date in cell D15 and six seperate numbers in cells E14:J14. I have a table in cells B24:M1000, with a date in column D and the six seperate numbers in columns E:J. I would like a formula in cell K15 that finds the date in cell D15 in the table B24:M1000 in column D and counts how many of the numbers in cells E14:J14 match the numbers in the table in column E:J for that specific date please. I am not sure whether to use count or match. Any help will be appreciated. Thanks in advance, Paul Have a look in the help index for COUNTIF Hi Don, I figured it out thanks. I used the following formula ,,, =SUMPRODUCT(COUNTIF(E$14:J$14,VLOOKUP(D15,D$24:M$3 2,{2,3,4,5,6,7}))) Kind regards, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count and match | Excel Discussion (Misc queries) | |||
count / match | Excel Discussion (Misc queries) | |||
Count if match any of 3 strings | Excel Worksheet Functions | |||
Count match of two criteria | Excel Programming | |||
match and count words | Excel Worksheet Functions |