View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default 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