Averages when using a filter

Good afternoon,

I am using the formula =AVERAGE('Year 13'!BV:BV) to work out the average value in column BV.

However, I would like the value to change if I filter one of the other columns, is there any way to do this?

Thanks

try =aggregate()
http://office.microsoft.com/en-gb/ex...010338704.aspx