Try this:

With this data on Sheet2 in the range A2:D8

1360-1...1st...100...5
1360-1...1st...200...10
1360-1...1st...300...10
1360-1...1st...400...30
1360-1...1st...500...15
1360-1...1st...600...60
1560-3...2nd...100...10

With this data on Sheet3 in the range A2:F2

001...1/8/08...1360-1...1st...100...500

Enter this formula on Sheet3 G2:

=SUMPRODUCT(--(Sheet2!A$2:A$8=C2),--(Sheet2!B$2:B$8=D2),--(Sheet2!C$2:C$8=E2),--(Sheet2!C$2:C$8<=F2),Sheet2!D$2:D$8)


--
Biff
Microsoft Excel MVP


"Cam" wrote in message
...
Hello,

I have an Excel to track performance. Sheet1 is performance table where
user
input their ID, date, part#, side, start sequence & stop sequence daily.
Then
on a reference sheet2 with field: part#, side, sequence#, time
(calculated).

What I would like to calculate is look at the start & stop sequence based
on
the part# & side then calculate how long (time) the operator spend on the
job
(part#). Thanks

Example:
Sheet1 - User input data
ID date part# side start seq stop seq
001 1/8/08 1360-1 1st 100 500
002 1/10/08 1560-3 2nd 600 1000

Sheet2 - Reference
part# side start seq time (min)
1360-1 1st 100 5
1360-1 1st 200 10
1360-1 1st 300 10
1360-1 1st 400 30
1360-1 1st 500 15
1360-1 1st 600 60
1560-3 2nd 100 10
..........

Result
Sheet3
ID date part# side start seq stop seq Total time
(calculated)
001 1/8/08 1360-1 1st 100 500 70

How should i go about linking the two sheets so it will calculate the time
based on when he start the sequence to when he stop the sequence? Thanks