Select data range between two dates (From Dropdown) then average

[Elfiraon]

Right now I have two cells that are drop-down (light green) in which I can choose date intervals. What I would like to be able to grab a set of data under the “Value” column using the date interval then take the average. Say my most recent date is “9/4/2014” and the other date is “9/2/2014”. I want to take the average from the data set “9, 10, and 20”, and return the value in the yellow cell.
All help appreciated! Cheers!

 

[bbott]

Welcome to the board. Try using the AVERAGEIFS function. Something like this assuming date ranges in A2 and B2 and table in A4:B8.

=AVERAGEIFS(B5:B8,A5:A8,"<="&A2,A5:A8,">="&B2)

 

[Elfiraon]

Sweet! Thanks bud

 

[bbott]

Sweet! Thanks bud

You're welcome.