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

Elfiraon

New Member
Joined
Sep 10, 2014
Messages
31


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!
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

bbott

Well-known Member
Joined
Feb 5, 2010
Messages
2,350
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,911
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top