Good Morning - I hope someone can help me with a Sumifs formula I require that is completely puzzling me.
I have attached a mock up of the output I require.
Basically I have 2 tables - a project table (Table 1) where there are 3 phases of work - Prep, Delivery and Commissioning. All 3 phases have start and finish dates, resource and qtys attached to them. So in effect I have 3 Resource Columns, 3 Start and Finish Columns and 3 QTY Columns.
Table 2 consists simply of a date header and the other headers consisting of the different resources. I need a formula that totals the resource requirement for the particular date in the date table - so adding together the 3 qty columns in table 1 for the particular resource and the date.
I think the attached will probably make more sense than my attempt to describe the problem ha.
I hope someone can help?