Hey All,

I have a problem with a code i am trying to use. This code,
SUMPRODUCT(--(ISNUMBER(FIND(C2,$A$2:$A$200,1))),--($B$2:$B$200=B2+5)), does not help me in solving a problem i am trying to solve. This is the problem. I have in A1:A100 twenty 6-digit numbers, and in B1:B200 is the years. I am trying to find if my value in C1 matches the values in A1:A100 range and the B1:B200 range. Let me give an example. C1=123456 and B1=1985. Now can you help me find a way to find the number of times C1 occurs in the A1:A200 range and at the same time match only the Years 1985,1986, 1987,1988 and 1989 in B1:B200. Remember the years 1988 and 1989 may not be in the range B1:B200. I need to find an efficient way to calculate for C1,C2,C3 and so on. Please help