russkris
Board Regular
- Joined
- Nov 7, 2012
- Messages
- 51
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
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
Last edited: