| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sum cashflows within date range given dates and cash flow
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NPV of Cash Flow Payments | Excel Worksheet Functions | |||
| Cash Flow | Charts and Charting in Excel | |||
| Cash flow charts | Excel Discussion (Misc queries) | |||
| Cash Flow | Excel Discussion (Misc queries) | |||
| Cash Flow Set-Up | Excel Worksheet Functions | |||
Linear Mode
