I am working on a calculation where one sheet has month on month cost for a year in columns. i.e. Jan Cost, Feb Cost, Mar Cost etc. in sequential order.
In another sheet, I am doing some calculations to prepare the category wise costs based on the first sheet. For each month, all the conditions are same except for the sum column. I need to change Month Column range every time for each month manually.
Is there a way to automate this calculation where I need to make minimum changes.
Example Data Set:
I need to sum the cost for each month based on category in following format:
Appreciate your help here.
Thanks