Curtis,

For January.

=SUMPRODUCT(('2004-JAN_05'!$C$2:$C$20000=$A43)*('2004-JAN_05'!$J$2:$J$200000)*(month('2004-JAN_05'!$B$2:$B$20000)=1)*('2004-JAN_05'!$J$2:$J$20000))

Change the =1 in the second condition to match the month number for
Feb-December. (2-12).


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=522800