I want a formula that will look at all the 'A' , 'B' and 'C' items and look at the relevant Quantity column and give the total quantity in a new column as shown below:

ITEM No Quantity ITEM Total Quantity
A A211 2700 A 10700
B D212 2700 B 2700
A U222 4000 C 2000
A Y546 4000
C Y315 2000

I am a newcomer to excel and appreciate that this is probably a very simple problem. Thank you for any help...