average with changing start and end points

Hi all,

I'm trying to use an average function with adjustable start and end points in the array. I currently have two drop down lists to designate a starting date and an end date. I'd like the write a function that returns an average over the period. Any ideas?

Thanks,

Alex

It sounds like a variation on the approaches used in a similar post might work for you. Check these files out.

http://www.excelforum.com/excel-form...ing-range.html

You can try AverageIFs

=AVERAGEIFS(A1:A100,B1:B100,">="&D1,B1:B100,"<="&E1)

A1:A100 is the range to average
B1:B100 is the range of dates
D1 is the Designated Start Date
E1 is the Designated End Date

Hope that helps.

Originally Posted by puzzlelover22

Hi all,

I'm trying to use an average function with adjustable start and end points in the array. I currently have two drop down lists to designate a starting date and an end date. I'd like the write a function that returns an average over the period. Any ideas?

Thanks,

Alex

Can you upload a sample file?