Spreadsheet: 38578d1236731272-summarizing-data-over-several-sheets-bolts-list-r1
Sheet: DETAILS2

BOLT | 20 LG Hex head bolt | 25 LG Hex head bolt | 30 LG Hex head bolt | 35 LG Hex head bolt | 40 LG Hex head bolt | 45 LG Hex head bolt | 50 LG Hex head bolt | 55 LG Hex head bolt | 60 LG Hex head bolt | 65 LG Hex head bolt | 70 LG Hex head bolt | 75 LG Hex head bolt | 80 LG Hex head bolt | 85 LG Hex head bolt | 90 LG Hex head bolt | 95 LG Hex head bolt | 100 LG Hex head bolt | 105 LG Hex head bolt | 110 LG Hex head bolt | 115 LG Hex head bolt | 120 LG Hex head bolt | 125 LG Hex head bolt | 130 LG Hex head bolt | 135 LG Hex head bolt | 140 LG Hex head bolt | 145 LG Hex head bolt | 20 LG socket head csk bolt | 25 LG socket head csk bolt | 30 LG socket head csk bolt | 35 LG socket head csk bolt | 40 LG socket head csk bolt | 45 LG socket head csk bolt | 50 LG socket head csk bolt | 55 LG socket head csk bolt | 60 LG socket head csk bolt | 65 LG socket head csk bolt | 70 LG socket head csk bolt | 75 LG socket head csk bolt | 80 LG socket head csk bolt | 85 LG socket head csk bolt | 90 LG socket head csk bolt | 95 LG socket head csk bolt | 100 LG socket head csk bolt | 105 LG socket head csk bolt | 110 LG socket head csk bolt | 115 LG socket head csk bolt | 120 LG socket head csk bolt | 125 LG socket head csk bolt | 130 LG socket head csk bolt | 135 LG socket head csk bolt | 140 LG socket head csk bolt | 145 LG socket head csk bolt
M8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M12 | 0 | 8 | 0 | 35 | 56 | 45 | 0 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M8CSK | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M10CSK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M12CSK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M16CSK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M20CSK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M24CSK | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M30CSK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | What i'd now like to do is summarize the quantity of each bolt length into one sheet to enable us to order them.
 | Details2 lists the possible bolt types and totals them using SUMIFS, but only takes data from sheet1 (named [NAME]). Note that cell [NAME] in Details2 shows a quantity of 50 for M12x75LG hex head bolt (from BoltsP1, D9) It does not account for the quantity of 5 shown in BoltsP2, [NAME]
 | Summary1 should then allow us to enter which bolt types occur and a total is then taken from Details2, rather than manually counting how often each bolt type occurs through the 3 sheets.
 | Is it possible to expand the formula to total the bolt types from anywhere on the 3 sheets? Or even discount Details2 altogether and allow the Summary1 sheet to directly quantify from BoltsP1/2/3?