Spreadsheet: 142477d1329855416-sumproduct-for-multiple-arrays-ignoring-zeros-yearly-totals
Sheet: Sheet1

Rework Totals Month to Month
Year: | 2012
 | Yearly | Department
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 |  | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | January | DEPARTMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS |  |  |  |  |  | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 |  | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Machining/Drilling | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Cutting Error | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Damaged in [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Engineering | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Defective Material | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Entry Error | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Too Short for Production | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | TOTALS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | February | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 | TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | March | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 | TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | April | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 | TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | May | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 | TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | June | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 | TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | July | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 | TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | August | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 | TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | September | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 | TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | October | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 | TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | November | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 | TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | December | DEPARTMENT
 | TYPE OF ERROR |  | HAND | SAW | CNC | ENG | FAB | BNDL | OFF | SHP | SPECIAL | TOTALS
 | TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Entry Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0