Could you please post a sample with the total you are expecting when your
input changes......

If this post helps click Yes
---------------
Jacob Skaria


"mthorn077" wrote:

No, not really familiar with Match and OFFSET function.

Here is a sample of how I have my data set up:
a b c d e
f g h
Emp. Number Employee Name Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09
1 J. Doe $2 $4 $7
$5 $8 $2


"Jacob Skaria" wrote:

Use MATCH() to find the column number of a specifc month/year. and use that
as a parameter in OFFSET() function and average that range..Hope you are
familiar with these formulas....if not post sample data and someone here
should be able to help...


"mthorn077" wrote:

I'm trying to do a rolling 12 month average of employee compensation.

Rows have employee name, columns have the month and year.

Any ideas???

Thanks for the help!