+ Reply to Thread
Results 1 to 4 of 4

Running Total of production by product ID

  1. 04-09-2016, 05:14 AM #1
    PhilBar
    PhilBar is offline
    Registered User
    Join Date
    11-12-2014
    Location
    Mexborough, England
    MS-Off Ver
    Office Pro 2019
    Posts
    39

    Running Total of production by product ID

    I would be obliged of some assistance could be provided to resolve the problem I'm having difficulty with. Daily records are maintained on batch production along with important batch code and shelf life detail.
    I am looking to populate the total batch volumes produced by product on the separate worksheet, so that as batch data is inputted that new batch weight is added to the previous total, thereby keeping total volumes produced up to date.

    I have attempted VLOOKUP formulas but to no avail, and any support would be greatly appreciated to identify the correct solution.

    Many thanks

    Phil
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-09-2016, 05:32 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,162

    Re: Running Total of production by product ID

    Try this instead:

    =SUMIF('Batch Log'!B:B,'Volume by Recipe'!A4,'Batch Log'!D:D)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-09-2016, 05:45 AM #3
    Crooza
    Crooza is offline
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Running Total of production by product ID

    not really sure what you're desired result is but try this in C4 of the 'volume by recipe' sheet

    =SUMPRODUCT(IF(A4='Batch Log'!$B$4:$B$100,1,0),'Batch Log'!$D$4:$D$100)

    its an array formula so use control + shift + enter to enter it and you'll get squiggly lines then drag the formula down column C
    Happy with my advice? Click on the * reputation button below
    Reply With QuoteRegister To Reply
  4. 04-09-2016, 08:32 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,162

    Re: Running Total of production by product ID

    Thanks for the reputation! Please mark the thread as solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Running total from a daliy worksheet into a montly total.
    By jakesib in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-15-2014, 10:49 PM
  2. Pivot Chart Running Total - Removing Current Year Future Total
    By car3489 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-27-2013, 03:35 AM
  3. Total production of energy in a specific months
    By S_T996 in forum Excel General
    Replies: 6
    Last Post: 07-09-2013, 02:56 AM
  4. [SOLVED] Need total production hrs available for 'next' month
    By tmanya in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2013, 03:36 PM
  5. Running total of multiple running totals
    By ashncg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2011, 05:20 PM
  6. Create Production Report to Calulate Shorts and Total Revenue
    By kikojones75 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2010, 02:52 PM
  7. [SOLVED] % of Running Total to Grand Total in Pivot Table
    By David in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2005, 04: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1