Hi Everyone,

I am trying to do some YTD formulas for a monthly reporting package off our main forecast model involving actual, plan, and forecast.

One of the tasks is to sum expenses from our main P&L model. For example Salary is found within different groups (Marketing, G&A, etc.) on the P&L. In column C I have this marked. Within the same model the Actual, Plan, Fcst, and LY month arrays are laid out across by month. If it's August, I would like to sum up all the cells through August if column C is marked "Salary", so I can get to the correct total Salary figure.

How do I go about getting a YTD sum for each of these arrays while essentially doing a sumif on "Salary".

Thanks,

Rakib