How can I add Part# Amounts when they are in multiple columns in Excel? -

i have 4 lists of part#s , each 1 has column amount. part#s may or may not repeated in each list, want 1 big list of every distinct part# total amount in each column. i'll show example.

part# amt part# amt part# amt part# amt     0       1       1       2 b     0   b     2   c     4   b     5 c     1   c     0   d     0   c     0 d     4   d     3   e     0   d     0  e     7   e     6   f     4   e     3 f     4   f     0   g     3   f     5 g     2   g     0   h     5   g     6 h     6   h     2       0   h     0     2 j     6 k     3 

and final column this:

part# amount     4 b     7 c     5 d     7 e     16 f     13 g     11 h     13     2 j     7 k     3 

what best way me go doing this? thank you

if have latest version of excel (2013+) pro plus edition, might able make use of data models , powerpivot add-in (ms:create data model in excel). however, following should work regardless of version, , tried/tested in libreoffice calc.

assuming have existing data in columns a:h, , have complete list of part# in column i, use following formula (modify suit dataset) j2:j12

=sumif($a$2:$a$12,i2,$b$2:$b$12)  +sumif($c$2:$c$9,i2,$d$2:$d$9)  +sumif($e$2:$e$9,i2,$f$2:$f$9)  +sumif($g$2:$g$9,i2,$h$2:$h$9) 

copy formula down, , should incrementally change i2 references appropriately, until final formula inside j12

=sumif($a$2:$a$12,i12,$b$2:$b$12)  +sumif($c$2:$c$9,i12,$d$2:$d$9)  +sumif($e$2:$e$9,i12,$f$2:$f$9)  +sumif($g$2:$g$9,i12,$h$2:$h$9) 

this yields following results:

part# amount      4  b     7  c     5  d     7  e     16  f     13  g     11  h     13      2  j     6  k     3 

this solution based on known inputs. dynamic, might need vba/macro, or other database tool sql or access.