Hi Everybody,
I has exhausted every Google, forum, and friend search I have so I am coming to the experts. I have attached a small sample of the workbook that I am working to help my description.
Row 2: Months of the Year
Rows 6 - 10: The construction cost of several different home types, with costs appreciating monthly)
Row 13: The number of homes with construction beginning in a given month
Row 14: The total cost of the houses that are started in a given month
Rows 15-17: The percentage breakdown of the construction cost if the as if the number in Row 13 was representative of the phase as whole.
Row 18: The contingency cost of the construction
The Problem: Essentially, my problem is that a house does not take 1 month to build, it takes 6. So what I want to is have Row 14 sum 1/6 of the total of each of the preceding 6 months to have a 6 month rolling cost of construction in a given month. This is important because I will draw down the loan on the amount in Row 14 on any given month and pay interest on the amount until the house is sold. Typically in the 7 month following construction beginning.
I have tried SUMIFS, and OFFSETS to no avail. Any help would be greatly appreciated.
Bookmarks