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!