How do I sum cashflows in date range.
 

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

How do I sum cashflows in date range.
 

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.

How do I sum cashflows in date range.
 

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

Regards,
Ryan--


--
RyGuy


"Ashish Mathur" wrote:

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.