I have an Excel Spreadsheet where I am trying to use a formula that will use the Offset function as the Range in the SumIfs function. The Offset function will need to pass the Column Value from a cell. There will be multiple conditions and criteria. SumIfs formula should run significantly faster than SumProduct so I would like to get this working.
I have loaded a Test file which has the formulas I need working in blue.