Medians - Filtered List by Year

[jennyliang]

Hi there,

I have a data set and a formula that calculates medians based on a filtered list. So that if the user wants to see the median in Group A, B or C, he/she can just filter for it, and the formula will adjust the median calculation based on the visible cells.

However, I want it to display it per year, which it's not set up to do right now.

Current formula: {=MEDIAN(IF(SUBTOTAL(2,OFFSET(F9,ROW(F9:F17)-ROW(F9),0)),F9:F17))}

For the current filtered list here, it should say:
2012: 3
2013: 2

I could just filter for 2012 and 2013 separately, and that would solve the problem - but I am trying to limit the amount of filtering necessary.

I've attached a sample data set.

Thanks!