Data Consolidation question

[slider.1978]

I have attached a sample of the sheet that I am working on. It is data for a time study to compute labor hours. I have managed to group everything together per "work order" and "Employee ID". I am trying to sum up the labor hours by work order. I know it sounds simple but I do have another question. Once the total hours are set. Are they still available in the same format when put in a Pivot Table?

any help would be appreciated.

thanks

[alansidman]

In I3 type =SUMIF($B$3:$B$306,B3,$H$3:$H$126) and copy down.

You would have to filter for Unique Values subsequently to narrow it down in an Advanced Filter.

or you could pivot it as in the attached.


At third option is to use the built in Sub totals function.

[judgeh59]

I just went straight to the pivot table and it gives you both sum of labor hours and average of required qty....no need for columns I and J....just my thought....