How to find the average of a range of cells?

So column A has a list of dates. Column B has a list of numbers.

I want to be able to type in a start date and end date and have excel return the Column B average for all the dates in between the two (inclusive of the start/end dates). I tried the following formula but it did not work:

=average(ADDRESS(MATCH(...)):ADDRESS(MATCH(...)))

Each individual =address(match)) function gives me the correct cell address, ex. $B$2, $B$15, but it won't calculate the average between the two cell addresses.

What should I do?

Thanks!

Try

=AVERAGEIFS($B$1:$B$24,$A$1:$A$24,">="&D1,$A$1:$A$24,"<="&E1)

D1 >> Start date
E1 >> End date

This would find the minimum value in column B that is greater than the start date matched against column A

Array entered >> Ctrl + Shift + Enter
=MIN(IF($A$1:$A$24>D1,$B$1:$B$24))

Hi anon,

You could use an advanced filter on your data and then use any other normal functin you want on the result. See Advanced Filter using Date Ranges at:
http://www.contextures.com/xladvfilter01.html

Thanks Marvin, always good to have options...

@anon,

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save