Originally Posted by Spencer101

You can accomplish that by adding another condition to the SUMPRODUCT.

Have a look at the attached now.

I changed the formatting on Column E of the "JC data" worksheet so the values are numbers and added the extra condition to the formula I provided before.

Is that of any use to you?

Worth noting that you have two jobs with the number 1003 so that value gets duplicated in the first and last job column.