Average offset help.

So I have a spread sheet that look like this

A B C D E....W
Country A 1980
Country A 1981
.
.
.
Country A 2004
Country B
.
.
.

With different variables in each column. I want to take a 5 year average i.e. country A between 1980-1984 and country A 1985-1989...etc.)

I tried using offset but I couldn't program it correctly. I don't mind doing each individual column...autofill wasn't doing what I wanted.

Sorry I don't know how to upload a sample. Here it is on google docs. https://docs.google.com/open?id=1fAL...tvFCVkw943E-5O

sample.xlsx

Sorry for my ignorance and I hope this is enough of a sample.

I don't know if my last post showed, but I talked to my friend who said I'm looking for a dynamic macro where both Average[A(x):B(y)]. I want to be able to see the averages all at once to be able to run a linear regression.

Could you use AVERAGEIFS() function? Like so:

=AVERAGEIFS(Sheet1!E:E,Sheet1!A:A,"Afghanistan",Sheet1!B:B,">="&1980,Sheet1!B:B,"<="&1984) gives result of 954.146 for GDP

replace the country name and start/end years with cell references that hold the values

that's really close to what I'm looking for, but is there a way to have the years increase every five years from 1980 to 2004? I'm working with 150 countries so any amount I can cut off can be helpful.

I'm not sure what you mean but have a look at the attached file.

There is a drop list for country name and another for start year. The end year changes according to the start year.

Here is the end product I am looking for. Sorry, I haven't been communicating well and I have no experience with macros of any nature. I was fooling around and I entered =Average($B:$b) and I got 1992. I think I took the average of the whole column at once. Is there anyway to have it more dynamic so it takes an average of one statitic (so like B2:B6) and then it moves to (b7:b11)?