Add using variable criteria

\1

ok so i realized i did not include the Letter and number portions of excel so just assume A,B,C..... 1,2,3 .... ect.

so what i need to do is Add the hours and Overtime Hours of all jobs with the same Job # together. the way i have this set up the job numbers only appear when that job is listed as having over time. the reason it lists regular hours as well is so the accountant will know if all of that day was in over time ,.... or if there are more hours in overtime than hours on that contract it means they worked time in the warehouse as well.

so i have tried working with sumproduct and sum if ,... but all the examples say the criteria is liike " Pen" or something like that ,..... but the job #'s are alwayse changing ,.... how can i tell it to specify a value in a cell and add the next "Bcollumn" of any ACollumn's" that match?