Conditional Sum Help Please
 

Hi there,

I have an application that creates an indented bill of material in
Excel.

Example

Parent Assembly
Child 1
Child 2
Sub Parent1
Sub Child x
Sub Child y

All these "items" have costs associated to them. IE the cost of "sub
child y" + "sub Child x" = the cost of "Sub parent1".

I am looking for a way in excel to "roll" the cost of the children
into their immediate parent and then continue on through the entire
Bill. This of course would have to work many times over as a Bill of
Material could have serveral hundred items with mutiple indents
(assemblies with sub-assemblies with sub-sub-assemblies.....)

Anyone have ideas on this?

Thanks,
Spyder