G Gerry Pat Apr 22, 2008 #1 I am trying to add up cashflows that fall within a date range from a string of dates and corresponding cash flows.
I am trying to add up cashflows that fall within a date range from a string of dates and corresponding cash flows.
A Ashish Mathur Apr 22, 2008 #2 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
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
R ryguy7272 Apr 23, 2008 #3 I piggy backed on AM's idea: http://www.freefilehosting.net/download/3g23m Regards, Ryan--