You can define the range that you want to work with by using the Offset
function. Something like:

=average(offset(b1,e4,0,f4-e4+1,1))

This will give you the arithmetic average of the cell range. However, it will
*not* give you the actual inflation rate for that period, because inflation
rates compound just like interest rates.

If you want the actual inflation rate, you need to calculate the future value of
$1 from month e4 to f4. If the actual inflation rate is what you want, post back
if you need more help calculating it.

--
Regards,
Fred


"Daniel9684" <Daniel9684@discussions.microsoft.com> wrote in message
news:65977D34-294D-4784-A2BF-065301A93E88@microsoft.com...
>I have a simple spreadsheet, in columns A and B are months of the year (from
> Jan 90 to present) and the Annual Inflation Rates for those years...
>
> In cell E4, I enter Month X, and in F4 I enter Month Y
>
> I need to work out the average of the corresponding inflation rates BETWEEN
> those two months
>
> e.g. if X is Jan 90 and Y is March 90, I need to find out the average of the
> inflation rate for Jan Feb and Mar 90.
>
> Anyone think they might be able to help me? I'm completely stumped!
>
> Thanks
> Daniel
>