+ Reply to Thread
Results 1 to 3 of 3

sum up 3 different shifts of production for multiple part numbers (Head ache)

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    sum up 3 different shifts of production for multiple part numbers (Head ache)

    Hello All

    MFG tab this raw data that is pasted in... This can't be a table or a pivot

    JLR Report Tab – in E3 this current counts the part numbers built on 06:30 – 1430 shift, then times it by the “normal box quantity” currently 13

    F3 counts items built between 14:30-22:30

    G3 counts items between 22:30-06:00

    Sometimes my production produces higher or lower box quantities, but this report assumes they are building in full box quantities of 13

    Is there way it could sum what’s been built column E on MFG Tab, but maintain the detail for each shift

    Please see attached

    Paul
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: sum up 3 different shifts of production for multiple part numbers (Head ache)

    "Is there way it could sum what’s been built column E on MFG Tab, but maintain the detail for each shift"
    I feel as if some further explanation needs to be provided in order to understand what you want. The formulas in E3:G3 on the JLR report sheet don't reference column E on the MFG sheet, so I can't see the relationship.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: sum up 3 different shifts of production for multiple part numbers (Head ache)

    May be this.
    In E3, F3, & G3 then copied down.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Schedule production allowing for part days
    By BRISBANEBOB in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-30-2016, 05:49 AM
  2. Replies: 8
    Last Post: 03-24-2016, 08:13 PM
  3. Pulling a value from a sheet with multiple possible part numbers.
    By Mr_Phil in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-17-2015, 10:41 PM
  4. Linking production figures to relevant part numbers in a separate workbook
    By sas123black in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-21-2014, 01:47 AM
  5. Calculating Downtime taking into acount 3 possible shifts of production.
    By Clintp1111 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-12-2013, 12:16 AM
  6. Calculating Max-Mix for multiple part numbers
    By bgk7472 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-17-2013, 12:08 PM
  7. Workbook_BeforeSave Head ache
    By JTH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1