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