Allocate Yearly Cost Across a Different # of Months for Each Record

[Kclynn]

Hello,
I have figured out how to allocate the cost across the different months but I want the very next cell in the array to have a different calculation based sum of the array. I am sure that I am not explaining this well. Example: I want the number in a cell (say 200,000) to be allocated over duration indicated in a cell (duration 7) then the very next cell (8th month) to but the sum of the 7 months array subtracted from the cell holding the 200,000.

Here are my formulas:
=IF(COLUMNS($R68:R68)>$P68,"",($I68*0.64/$P68)) This is in the first 7 cells
=I68-(SUM(R68:V68)) this is in the 8 cell

Is there a way to combine this so it would be automatically calculated no matter what the duration number is.

 

[Kclynn]

This is would be correct.
where does this 0.64 comes from? does that mean always 64% of amount to be distributed over x number of months mentioned in column P?
if the above is true , the balance to be placed in the cell next to last month would always be 36% of column I?

Hi - I appreciate all the help you have been trying to provide for me just was curious if you were still working on a solution?

 

[Kclynn]

I think the UNIQUE function is exclusive to O365 insider members currently and won't be released for a few months if I am correct.

So if you had months number = 7, would you then fill Jan-Jul with figures, and put the final formula in for August?

I wanted to thank you for trying to provide a solution for me. I appreciate any and all efforts greatly.