Hi,

Assuming your date range is like this (Range A1:B6)

Date Cash flows
12-Jan-08 100
15-Jan-08 421
28-Jan-08 742
10-Feb-08 1063
05-Jan-08 1384

In range A8:A9, enter the range (such as)

01-Jan-08
20-Jan-08

In cell B8, enter the following formula
=SUMPRODUCT((A2:A6=A8)*(A2:A6<=A9),B2:B6)

--
Regards,

Ashish Mathur
www.ashishmathur.com
http://www.linkedin.com/in/excelenthusiasts

"Gerry Pat" <Gerry wrote in message
...
I am trying to add up cashflows that fall within a date range from a
string
of dates and corresponding cash flows.