=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