Finding Average of a range based on values in another range

[cyglor]

This is what I want to do.
I need to find the average value in Column B that is in between two numbers (or more accurately between the range of two numbers) in column A. For example I want to find the average column B value that is in between 2000 and 2001.

Column A Column B
2002 14.5
2001.9 13.5
2001.8 14.1
2001.7 15
2001.6 12.9
...
2001.0 11.5
2000.9 10.9
2000.8 11.9
...
1999.9 10.5
1999.8 15.2

This goes on for over 5000 rows. Is there a way to automate the process. I have tried AverageIFs and CountIfs and tried combinations there of, but I can't seem to get it to work.
Is there a single formula or steps that can get this quickly?

Cheryl

 

[cyglor]

The formatting got jumbled. The first column ends on the .# and the second column are the last 3 numbers.

 

[Aladin Akyurek]

e2: 2000

f2: 2001

g2:

=averageifs(b:b,a:a,">="&$e2,a:a,"<="&$f2)

 

[cyglor]

That works. Thank you!

 

[Aladin Akyurek]

That works. Thank you!

You are welcome.