View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gerry Pat Gerry Pat is offline
external usenet poster
 
Posts: 2
Default How do I sum cashflows within date range given dates and cash flow

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.