I have a loan ammortization that I would like to compute yearly interest on
without having to go into the schedule and add subtotals for each year.
Dates are stored in column F and Interest is stored in column I. The formula
needs to look at column F and determine where a year starts and stops (assume
2008 for this example) and then sum the corresponding cells in I.

Any help is appreciated.

Thanks

=SUMPRODUCT((YEAR(F1:F1000)=2008)*(I1:I1000))

similar for the other years.
--
Gary''s Student - gsnu200839


"Dave" wrote:

I have a loan ammortization that I would like to compute yearly interest on
without having to go into the schedule and add subtotals for each year.
Dates are stored in column F and Interest is stored in column I. The formula
needs to look at column F and determine where a year starts and stops (assume
2008 for this example) and then sum the corresponding cells in I.

Any help is appreciated.

Thanks

Hello Gary's

Thank you for the information. I appreciate the fast response. The formula
was what I was looking for. Since posting the original question, we are
taking the schedule in another direction. Is there a macro that I can use to
add a yearly interest total line to the schedule after it is set up? If the
schedule goes for 15 years, I want to press a button once the schedule is
done and have it go to the end of each calendar year and add a line that has
a formula that sums that year's interest.

Thanks

"Gary''s Student" wrote:

=SUMPRODUCT((YEAR(F1:F1000)=2008)*(I1:I1000))

similar for the other years.
--
Gary''s Student - gsnu200839


"Dave" wrote:

I have a loan ammortization that I would like to compute yearly interest on
without having to go into the schedule and add subtotals for each year.
Dates are stored in column F and Interest is stored in column I. The formula
needs to look at column F and determine where a year starts and stops (assume
2008 for this example) and then sum the corresponding cells in I.

Any help is appreciated.

Thanks