Hello,

I need help with following:

In Sheet 1 I have columns A3:M31. In column A are listed cost centers (once cost center occur more then once) and in other columns (B:M) are amounts per period (January-December). Cell F1 contains current period (e.g. 05-2015)

In sheet 2 in column L are again cost centers (only once). In column H there should be a formula that would return sum of the amounts per cost centers for period defined in cell F1 in sheet 1.

Thank you in advance.