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
How do I post specific dates into a colums labled only by Year? 3
identify which years are contained within a range of dates 2
Template for 40-year quarterly cash flow mixed with some monthly flows 1
Using the IRR function in Access 1
How do I fill a sum formula for for quarters into adjacent years 1
Sumif function with a date range condition statement 4
Test if a date falls within a given range of dates in Excel? 6

Top