formula to write-off the amount in cells evenly and sum them.

[zaska]

Hello,

I have amounts to be written off in Row No.2. I want to write off the values equally over a period of years depending on the periodicity entered in excel say for example ( 3 Years, 4 Years, 5 Years etc.,) I was able to do this manually. Can anyone help me with the logic to build a formula in single cell.

I am herewith attaching the file wherein I have written off the values for 3 years.


Thank you

[Bo_Ry]

Please try

=SUM(B3:B9)

or

=SUM(INDEX($B2:B2,MAX(1,COLUMNS($B2:B2)-$M$2+1)):B2)/$M$2