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