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