Getting an average between dates

[aislinnlc]

Hi again

I am trying to find the formula so that i can return the average % into a cell.

I have a column which give me a %

I have a large amount of data in dates. I need to return the average % into a cell but between dates.

For example, in 2014-2015 the average % was ................and so on.

Any help will be gratefully received

 

[Misca]

By far the easiest solution would be to use the AVERAGEIFS formula:

=AVERAGEIFS(B2:B22,A2:A22,">="&D3,A2:A22,"<"&E3)

This would return the average of values in B2:B22 if the date in A2:A22 is greater than or equal to the date in D3 and smaller than the date in E3.