Formula to Sum values until level is = or lower (BOM)

Hi guys,

First time posting here, hope I can get it right.

I need a formula to sum values until it reaches the same/lower "level" of the pn I want.

Thanks in advance

Try this in G2:

=SUM(D$1:INDEX(D:D,MATCH(F2,C:C,0)))

and copy into G3. It will sum all the values up to the pn number (not sure what the xxxx values are for). The results differ from your values, so perhaps I haven't understood your requirements properly.

Hope this helps.

Pete

Thank you for your time Pete, I guess is somewhat related to that but not quite.

The xxxx would be other pns, I just was too lazy to write them.

What I want is related to the level.
So for pn 6868 in the example, its level is 2 so the formula would sum all levels higher (its "sons" like 3,4,5,6 and so on) until it reaches the same or lower level (0,1,2).


Attachment 835556

G2

Please Login or Register  to view this content.

Cell G1 formula , Drag down

Formula:

Please Login or Register  to view this content.

Originally Posted by windknife

G2

Please Login or Register  to view this content.

That one did it, thank you all for the support!

Originally Posted by wk9128

Cell G1 formula , Drag down

Formula:

Please Login or Register  to view this content.

Also worked, thank you

You are welcome.
-----------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.

Just a minor correction, at least for me: Replaced the last argument -1 to -2 and it did the trick, before it was adding items with the same level

Formula:

Please Login or Register  to view this content.

@lgrbueno You're Welcome. Glad to help . Thank You for the feedback and rep.