Total Hours worked per Job or Worker

I'm trying to improve the log that I use to track my workers whereabouts so I can improve job costing. I've been manually adding up different jobs from the attached sheet but want to make it do this automatically. I've got a column with hours worked on a job, then a column with the specific number on for that job, and then a column with the job's name. I want to find out how to make something at the bottom of the sheet that will take column E and add up all values in column F that correspond with that certain value in E. Please see attached sheet, I can write better instruction on there. Thank you.

Use

=SUMIF($E$6:$E$56,1,$D$6:$D$56)

Replace the highlighted in blue to 2 or 3 to get results for the others

Hi DJohnson2 and welcome to the formum,

Could you edit your original post and change the title to something like "Total Hours worked per Job or Worker" so we can find it later. Your title is too generic (common).

See the attached for how I'd be doing this problem. Hope this helps. Did you change the thread title yet?