Cumulative summing: sum rows 1-12, then rows 1-24, 1-36, etc..

[Matt G.]

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.

 

[JE McGimpsey]

One way:

Take a look at CUMIPMT in XL Help. It's part of the Analysis Toolpak
Add-in (Tools/Addins...).

Another:

C1: =SUM(B$1:B1)

and copy down.

 

[Bernd]

Hello,

If your data is in column A starting at row 1 then enter into B1
=SUM(A$1:INDEX(A:A,ROW()*12))
and copy down.

Regards,
Bernd