Dear Experts,
Please find here attached Sample workbook, where i am expecting the output in the yellow highlighted sections in Actuals P&L tab in Sales & Payroll Sections based on two different years tabs. Sales section criteria is from Cell C9 to C10 in Actuals P&L Tab but the Payroll Section criteria would be at Cell B14 in Actuals P&L tab and in column C in both the tabs.
Indirect criteria is located at Cell I2 in Acutals P&L tab.
Request to you kindly do help me out. Many thanks and kind regards,
Neilesh
Sample Workbook_Neilesh.xlsx
Bookmarks