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