Forum Discussion
Excel repeat cost in cash liquidity forecast based on start date
Hi, I am trying to create a budget cash liquidity forecast for a 5 year plan Each cost group has it's own sheet with information and calculation. Some cost is fixed month by month. Some cost a...
That's not clear how rows in summary code are connected to rows in planning sheet - by position, by ID or how?
Without that you base the formula on SUMIFS, like
=SUMIFS( horisontal range,
alldates headers, ">=" & start of period,
alldates headers, "<=" & end of period
)