All, I have a multi-level bill of material and I want to create a function that will sum it properly without having to sum up each level manually. Here is an example:
Level Item Quantity Cost 1 Chair 1 $39 2 Seat 1 $15 3 Cushion 1 $10 3 Base 1 $5 2 Leg 4 $1 2 Back 1 $20 3 Leather 1 $12 3 Wood 1 $8 In my example, I have a chair. The chair is composed of a seat ($15), four legs ($1 each), and a back ($20) for a total of $39. However, the seat and back are composed of subcomponents. So, my input values should look like this: Level Item Quantity Cost 1 Chair 1 2 Seat 1 3 Cushion 1 $10 3 Base 1 $5 2 Leg 4 $1 2 Back 1 3 Leather 1 $12 3 Wood 1 $8 And I want excel to figure out the blanks for me using a formula. Can this be done? Essentially I'm looking for a formula that will sum just the level below it, until it runs into an equal level, and then it stops. So, in the case of the seat, it should know to sum the cushion and the base, but not the leather and the wood. Thanks for the help! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
