ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cumulative summing: sum rows 1-12, then rows 1-24, 1-36, etc.. (https://www.excelbanter.com/excel-programming/384953-cumulative-summing-sum-rows-1-12-then-rows-1-24-1-36-etc.html)

Matt G.

Cumulative summing: sum rows 1-12, then rows 1-24, 1-36, etc..
 
I'm working on an ammortization calculation sheet. I want to add up
the cumulative interest, etc. I therefore want to sum the first year
(rows 1-12) then sum the first and second years (rows 1-24), then sum
the first, second, and third years (rows 1-36), etc...

Any idea on a method for accomplishing this?

Thanks.



All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com