find and add vaules

[MLT]

Is this possible?

Sheet 1
Column A = list of part numbers on each purchase order ( a part number will
show up many times)
Column H = In stock ready to ship

Sheet 2
Column A =list of all part numbers
Column C = addition of column H sheet 1, ( for a grand total ) of all the
times that part number shows up in column A on sheet 1

Can it be done?
thank you

 

[T. Valko]

Try this in column C of Sheet2:

=SUMIF(Sheet1!A:A,A1,Sheet1!H:H)

Copy down as needed.