Sum based on a specific cell and time range

[pmw1980]

Hello ALL

any help would be great

Mini Report Tab
in E3

i would like a formula to work out the amount of parts that has been built between a time of 06:30 - 14:30. but specific for the part numbers that appears in in column A

 

[JPARKHURST]

This one drove me nuts for a while when I ran into it the other day.

=SUMIFS(SUM_RANGE,CRITERIA_RANGE_1,CRITERIA1,CRITERIA_RANGE_2,">="&CRITERIA2,CRITERIA3_RANGE,"<="&CRITERIA3)

in your case

criteria1 = part number
criteria 2 = 6:30 (I put mine into a cell so I would not have to modify the formula)
criteria 3 = 14:30 (same on reference cell)

HTH,

Jon