This seemed to work changing the original suggestion posted slightly.

{=SUM(IF((A1:A4={1,2,3})*((B1:B4DATE(2005,12,1))* (B1:B4<DATE(2005,12,31))),C1:C4))}

The DATE is your start and end dates.


Cheers,

Steve


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