data comparison
 

I have a sheet with a list of part numbers and the time it takes to make each
part. On another sheet, I have a list of part numbers with the quanity due
and and due date. I am trying to find out a way to calculate the total hours
need to make all parts in a given week, month, quarter, etc...