How to Look first column duplicates items and do sum for 3rd column accordingly

[pankajgrover]

Hi, I have data like below:

A B C
Item Price Qty
Pencil 25 1000
Rubber 20 500
Pencil 26 1500

I want to look A column duplicates and sum for 3rd qty column accordingly , so that final outcome will be like
Pencil 2500
Rubber 500
So this how to do in excel with help of formula , Kindly guide me .
Thanks

 

[jdellasala]

PLEASE use XL2BB!
This is very easy with 365:

Book1
	A	B	C	D	E	F	G
1	Item	Price	Qty		Item	Price	Qty
2	Pencil	25	1,000		Pencil	51	2500
3	Rubber	20	500		Rubber	20	500
4	Pencil	26	1,500
Sheet1

Cell Formulas
Range	Formula
E2:E3	E2	=SORT(UNIQUE(A2:A4))
F2:G3	F2	=SUMIFS(B2:B4,$A$2:$A$4,$E2#)
Dynamic array formulas.

I kept it simple, but this could even be put into a single formula, but that's above my pay grade!

 

[pankajgrover]

Wow, Thanks its working good.