[B]counting multiple occurences with data missing[/B]
 

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


--
Tomac
------------------------------------------------------------------------
Tomac's Profile: http://www.excelforum.com/member.php...o&userid=31555
View this thread: http://www.excelforum.com/showthread...hreadid=513877