help with a formula
 

Hi

I need a formula to calculate the following: a variable annual interest
rate that changes over a variable number of years, applied to a figure.
The interest needs to applied to the compounded figure each year.
However, I need the sum of all of the years added together rather than
the compounded effect. This should be easy i feel, but I am struggling
with the variable interest over variable years.