In my workbook, daily time sheets are kept from two employees. On a third sheet, I have the job name and category (along with some other information). I want a column on this third sheet that will look at both of those daily sheets, and if the job name AND the category (in two different columns) on that sheet match the job name and category on the third sheet, I want it to add all the instances of time worked when both of those conditions are met.

I'm trying to track the time spent on any particular stage of work on each job we do. So, in job "Smith", we spent 4 hours on assembly, 2 hours on packing, etc....

Please help?