Addition of Columns

[STROBE]

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...

[STROBE]

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 Quantity
A 2700
B 2700
A 4000
A 4000
C 2000

Result:

ITEM Total Quantity
A 10700
B 2700
C 2000


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

[mrice]

You need to use the SUMIF function - see Excel Help on this for more details.

[oldchippy]

Try this in E2 and drag formula down to E4

=SUMPRODUCT(--($A$2:$A$6=D2)*($C$2:$C$6))

[VBA Noob]

STROBE,

Welcome to the forum. Please read rules below.

I've merged your duplicate post this time but next time they will both be deleted without warning unless you follow the rules.

VBA Noob