=SUMPRODUCT(--(A1:A8="Pen")*(B1:B8))
--
Gary''s Student - gsnu2007a


"adeel via OfficeKB.com" wrote:

I have large number of data as follows.....

For example...

Item Qty

Pen 10
Pencil 15
Rubber 20
Car 5
Motorcycle 50
Car 30
Train 100
Rubber 120

I want total number of Qty in one cell for every individual item.....eg. for
Car = 35, for Rubber = 140

I think my question is clear. please if some one can help me. i shall be
highly thankful

--
Message posted via http://www.officekb.com