EJ,

You could use SUMPRODUCT,

=SUMPRODUCT((A1:A10=H1)*(A1:A10<=H2)*(B1:B10))

Where H1 is your start date and H2 is your end date. A1:A10 your dates
and B1:B10 your values to sum. Otherwise use the array formula,

=SUM(IF(A1:A10=H1,IF(A1:A10<=H2,B1:B10,0)))

Commit with Ctrl-Shift-Enter not just enter. This will put {} around
the formula.

HTH

Steve


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