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.

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.


In article <(E-Mail Removed)>,
"Matt G." <(E-Mail Removed)> wrote:

> 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.

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