How do I sum cashflows in date range.

  • Thread starter Thread starter Gerry Pat
  • Start date Start date
G

Gerry Pat

I am trying to add up cashflows that fall within a date range from a string
of dates and corresponding cash flows.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NPV of cashflows to assess contribution to a joint venture 2
Using XIRR in an array formula 9
Copying formula to sum multiple columns 3
Automatic cashflow 0
XIRR versus IRR help! 6
Using SUMIF to add data between a range of dates 2
How do I sum cashflows within date range given dates and cash flow 1
Working with arrays as arguments 6

Back
Top