Count or Match Help Please

P

Paul Black

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
 
D

Don Guillett

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
 
P

Paul Black

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$32,{2,3,4,5,6,7})))

Kind regards,
Paul
 

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

Top