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

On Jul 11, 6:08*pm, Paul Black <paul_blac...@hotmail.com> 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

On Jul 12, 1:54*pm, Don Guillett <dguille...@gmail.com> wrote:
> On Jul 11, 6:08*pm, Paul Black <paul_blac...@hotmail.com> 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$32,{2,3,4,5,6,7})))

Kind regards,
Paul