Hello Guys, I’m appealing to the experts on this board for assistance in a problem that I have been unable to find a solution to (my appologies if this has already been previously posted -- I couldn't find it).
My situation is:
I need to create an overview per Product and Range of time:
My criteria are: The formula should Find the type of Product and SUM If it’s upper than Start hour (COL I) and lower than End Hour (COL J), and also make the sum in the night shift (i.e. from 22:00 PM to 0:30 AM or 1:00 AM to 6:00 AM). So that's why I choose the formula SUMIFS
Table A - I input de information manually on the following colluns:
COL C – Type of Product
COL D – Start Pause
COL E – End Pause
COL F – Variation between COL C and COL B
Table B - Overview by Type of Product and per range of time.
COL H – Type of Machine
COL I AND J – Start and End Period
COL K – FOMULA
=SUMIFS($F:$F,$C:$C,$H$4,$D:$D,">="&I4,E:E,"<="&J4)
I trully hope that I'm clear as possible in my explanation. I appreciate any feedback.
Thanks in advance,
Eduardo Rocha
Bookmarks