=SUMPRODUCT(--(A1:A6="1/1/2004"+0),--(A1:A6<="3/31/2004"+0),--(B1:B6="List"),C1:C6)

OR

=SUMPRODUCT(--(A1:A6=D1),--(A1:A6<=E1),--(B1:B6=F1),C1:C6)

...where D1 is the start date, E1 the end date, and F1 the "Type" of
interest.

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=276136