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.
Bookmarks