|
|
#1
05-22-2017, 08:11 AM
|
|||
|
|||
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, 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 List max values in a range
|
Bella06 | Excel | 10 | 04-20-2017 10:05 AM |
| Is there a way to exctract a single page from Word? | mobileone | Word | 1 | 04-05-2017 02:27 PM |
| Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
| Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
|
I need to add multiple values based on multiple criteria in a cell not sure what to do
|
AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
Mac OS X 
Office 2016 for Mac
Threaded Mode