I am comparing the budget YTD vs Actual YTD. if I am in period 5 of the year, how do I get only the sum of the first 5 columns to display in the budget YTD column.
If N7=5, then sum B8:f8
Are you able to see my file? Cell O7 is linked to the cover page where it defines the period number and month. If O7=period 5, then the formula must sum B8:F8.
Attachments
Sadhna Demo Company - Financial Model Exercise (12 8 2017 SG).xlsx
Thank you so much. This worked perfectly. Do you by any chance know how to do the following:
- i have used sumif to extract information in my balance sheet
- how do I reclassify credit accounts which are in debit to automatically post to accounts payables.