Posted to microsoft.public.excel.worksheet.functions
|
|
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.
|