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

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

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