+ Reply to Thread
Results 1 to 1 of 1

Advanced Multi-Level Parent Summation (BOM type)

  1. #1
    Registered User
    Join Date
    03-28-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    6

    Advanced Multi-Level Parent Summation (BOM type)

    I have a followup to my original thread with a new request for help with a more complex calculation, hence the new thread. I can't post a link to the original thread, but it was called "Multi-Level Parent Summation (BOM Type).

    What I am looking to do now is add a sumproduct into the rollup array. In the attached workbook, column A represents the levels of a Bill of Materials (BOM), Column B and Column C are two associated values that need to be multiplied together to calculate the Parent Sum. Column D shows manual calculations for the Parent Sum. The tricky part seems to be that a Parent rollup will itself have to be multipled by the "Multiplier" (column C), in order for the total parent rollup to be correct. End goal is one formula in Column D that can be copied down, that will grab the appropriate child values from columns B and C and create a total Parent value for each line item. Thanks so much!
    Attached Files Attached Files

+ 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] Multi-Level Parent Summation (BOM type)
    By LucyL in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-12-2022, 04:34 PM
  2. [SOLVED] Extracting the 1 level lower part numbers based on Level numbers in multi level BoM
    By Sekars in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2022, 05:35 AM
  3. Macro needed to convert multi-level BOM to single-level BOM as per attached file
    By AhmedSaad in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 05-12-2021, 08:31 AM
  4. Format the second level of multi-level category axis - clustered chart
    By mushkitoes in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-04-2018, 09:30 AM
  5. [SOLVED] creating Multi-level list styles using existing multi-level list?
    By JimmyWilliams in forum Word Formatting & General
    Replies: 2
    Last Post: 08-28-2017, 12:21 AM
  6. Conditional summation of a multi=level parts list
    By sheldh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2014, 07:31 PM
  7. Multi-Level Array Type Mismatch Error
    By CrazyFileMaker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-04-2009, 06:20 PM

Tags for this Thread

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