+ Reply to Thread
Results 1 to 7 of 7

Calculate Material Release - Bill of Material

  1. 01-16-2021, 07:28 PM #1
    mgoh
    mgoh is offline
    Registered User
    Join Date
    12-31-2020
    Location
    indonesia
    MS-Off Ver
    2016
    Posts
    10

    Calculate Material Release - Bill of Material

    Could anyone help me with this problem

    I would like to calculate sum qty material release based on qty product produced vs bill of material of the product

    MATRELEASE_PROBLEMS.png


    Attached sample excel problem sheet

    Thanks Guys
    Attached Files Attached Files
    Last edited by mgoh; 01-17-2021 at 06:40 AM.
    Reply With QuoteRegister To Reply
  2. 01-17-2021, 12:25 AM #2
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Calculate Material Release - Bill of Material

    In K4 then copied across.
    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 With QuoteRegister To Reply
  3. 01-17-2021, 04:21 AM #3
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2502 and WPS V2024(12.1.0.18543)
    Posts
    3,866

    Re: Calculate Material Release - Bill of Material

    K4 cell, array formular , Drag down and accross

    HTML Code: 
    Reply With QuoteRegister To Reply
  4. 01-17-2021, 06:16 AM #4
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Calculate Material Release - Bill of Material

    Please try at K4

    =SUMPRODUCT(SUMIFS($C$4:$C$9,$A$4:$A$9,$E$4:$E$7,$B$4:$B$9,$J4),($G$4:$G$7=K$3)*$F$4:$F$7)
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  5. 01-17-2021, 06:23 AM #5
    mgoh
    mgoh is offline
    Registered User
    Join Date
    12-31-2020
    Location
    indonesia
    MS-Off Ver
    2016
    Posts
    10

    Re: Calculate Material Release - Bill of Material

    Quote Originally Posted by kvsrinivasamurthy View Post
    In K4 then copied across.
    Please Login or Register  to view this content.
    Thanks... it's working only product "A"

    It is not caculating product "B"

    It's still good work.. can you look more to it

    Thanks...
    Reply With QuoteRegister To Reply
  6. 01-17-2021, 06:28 AM #6
    mgoh
    mgoh is offline
    Registered User
    Join Date
    12-31-2020
    Location
    indonesia
    MS-Off Ver
    2016
    Posts
    10

    Re: Calculate Material Release - Bill of Material

    Quote Originally Posted by wk9128 View Post
    K4 cell, array formular , Drag down and accross

    HTML Code: 
    Great... it's working...
    Thanks........
    Reply With QuoteRegister To Reply
  7. 01-17-2021, 06:40 AM #7
    mgoh
    mgoh is offline
    Registered User
    Join Date
    12-31-2020
    Location
    indonesia
    MS-Off Ver
    2016
    Posts
    10

    Re: Calculate Material Release - Bill of Material

    Quote Originally Posted by Bo_Ry View Post
    Please try at K4

    =SUMPRODUCT(SUMIFS($C$4:$C$9,$A$4:$A$9,$E$4:$E$7,$B$4:$B$9,$J4),($G$4:$G$7=K$3)*$F$4:$F$7)
    It's working... and simple to understand

    Great work.... thanks......
    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. Copy down cells with SKU IDs in a Bill-of-Material
    By anasman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2017, 04:45 PM
  2. Multi level Bill of material
    By neorez in forum Excel General
    Replies: 36
    Last Post: 03-09-2016, 02:05 AM
  3. Bill of material in excel file
    By wiewie002 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-09-2015, 09:40 AM
  4. general bill of material
    By francesco.ciani88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2015, 02:04 PM
  5. Hide sheets in a Bill of Material
    By ajbele in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2013, 06:13 PM
  6. bill of material, assemblies
    By jamesw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2011, 01:53 PM
  7. Multi level Bill of material
    By neorez in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-21-2011, 04:35 AM

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