SUMPRODUCT will work. Assuming your table is in A1:D10.
=SUMPRODUCT((A2:A10="Edgar")*(D2:D10DATE(2006,2,1 4))*(D2:D10<DATE(2006,2,28))*(C2:C10))
If you want to include the 14th and 28th in your calc then,
=SUMPRODUCT((A2:A10="Edgar")*(D2:D10=DATE(2006,2, 14))*(D2:D10<=DATE(2006,2,28))*(C2:C10))
HTH
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=522658