Exctract values from multiple list and sum them up
I have a list of materials with quantities for several assemblies. Each assembly has some duplicate material with differing quantities. I want to tally them up to find how many of each material are needed. How can I do that in either cell functions or macros?
In short, if you look at my attachment, I want to get from the assembly lists there to the Total list there.
Last edited by kitzka; 05-22-2017 at 08:36 AM.
Reason: Table did not come out right,
|