Formula to Evaluate Range and Sum Different Column
 

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

Formula to Evaluate Range and Sum Different Column
 

=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

Formula to Evaluate Range and Sum Different Column
 

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