SUMIFS help with multiple criteria

[russkris]

Hi,

I have a project with a limited budget however one component is not included in the budget but still need to keep track of the cost.

The project has 6 components and each component has Normal cost and overtime cost.

This is the sheet supervisors are filling out [Table1]-[Table30]

and this is the sheet, that will be used to create graphs etc [Table36]

What I would like to happen, is the Normal time for the green components split into the first Normal/Overtime column and the red component go into the Overtime2/Normal2 columns

Just not quite sure how to use SUMIFS

 

[russkris]

Or would something like this be easier to create a formula

 

[russkris]

Still on the hunt if anyone knows a way to achieve this.

Looking at the second post as a way to split the costings.