Hi all

I have a senario.

Worksheet 1

Part Quantity
A 20
B 14
C 9
D 19
B 31
G 12
K 10
E 32
B 17
.. .
.. .
.. .
C 43

Worksheet 2

Part Total
A 20
B 62
C 52
.. .
.. .
.. .

I need total quantities in worksheet 2 which summarizes all matching
part number (A,B...) in worksheet 1. If there is only one possible
match, I can use VLOOKUP. But now I need a sum. Please give me some
idea. Thanks in advance.

Best, YU