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

"Gerry Pat" wrote:

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.