How to count elements on a structure
I have a “Request” sheet that references a bill of material (BOM) structure, similar to the table below
I am trying to determine that if in my “Request” sheet I get a request for Part C, then I should be able to count from my BOM sheet that I only need 3 units of Part E, but if I have an order for Part B, then I would need 4 units of part E.
I have tried to use Ancestors, rows counts, etc, but so far I have not been able to come with a logic that allows me to do this.
Your help will be greatly appreciated!
Thanks in advance.