How do I sum cashflows in date range.

[Gerry Pat]

I am trying to add up cashflows that fall within a date range from a string
of dates and corresponding cash flows.

 

[Ashish Mathur]

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

 

[ryguy7272]

I piggy backed on AM's idea:
http://www.freefilehosting.net/download/3g23m

Regards,
Ryan--