Automatic Look up and count from time of day

[pmw19800]

hello All
I would like a formula to identify what’s been built at what time on a production line.

Mini Report & JLR Report Tab
E2 needs to look at the part number in column A and count what’s been built for that particular part within the MFG tab. Whilst also looking at the time of the build and then return what’s been built at what time, I’ve highlighted an example in orange
Data in the MFG will constantly change

[davsth]

its not clear why you are multiplying by 13 and the quantity change is 12, and why the formulas have been entered as arrays, which is unnecessary.

=IF('Mini Report'!A12="","",COUNTIF(MFG!$A$2:$A$212,'Mini Report'!A12))*13

would become
=IF('Mini Report'!$A12="","",COUNTIFS(MFG!$A$2:$A$212,'Mini Report'!$A12,MFG!$C$2:$C$212,">="&6/24,MFG!$C$2:$C$212,"<"&14/24))*13
=IF('Mini Report'!$A12="","",COUNTIFS(MFG!$A$2:$A$212,'Mini Report'!$A12,MFG!$C$2:$C$212,">="&14/24,MFG!$C$2:$C$212,"<"&20/24))*13
=IF('Mini Report'!$A12="","",COUNTIFS(MFG!$A$2:$A$212,'Mini Report'!$A12,MFG!$C$2:$C$212,"<"&6/24)+COUNTIFS(MFG!$A$2:$A$212,'Mini Report'!$A12,MFG!$C$2:$C$212,">="&22/24))*13

for your 3 time slots

[pmw19800]

thats great thankyou, The 13 is used on the JLR TAB, Moni tab is 12