How do I sum cashflows within date range given dates and cash flow

G

Gerry Pat

I am attempting to take a string of daily cash flows and place them into
quarterly time periods. It would be great to write a formula that looks at a
whole range of dates, sorts out which ones fall within given quarter of the
year, sums up the cash flows for that quarter, and then enters a single net
dollar cash flow amount for that quarter.
 
J

Jim

How about =SUMPRODUCT(--(date_range>=start date),--(date_range<=end
date),(cash_flow_range))
 

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

How do I sum cashflows in date range. 2
Discounting Cashflows 1
Template for 40-year quarterly cash flow mixed with some monthly flows 1
How do I fill a sum formula for for quarters into adjacent years 1
How can I Lookup and sum payments for cash flow forecast? 4
How do I count in a range of dates? 2
Sumif function with a date range condition statement 4
How does one get excel sum of a column based on given dates range 3

Top