Formula to consolidate yearly data

[rizmomin]

Hello:

Please refer to attached file.
I have data as shown, Column A is the year and Column B is the month and rest are some sales data.
I need formula in cell O2:Q13 to consolidate the value selected from dropdown list in cell N1.
In this case i have selected "Total" which is column K
So basically consolidate column K and have in cell range O2:Q13

Let me know if you have any questions.
Thanks.

Riz