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))
 
Top