SUM OF NUM VALUES WITH CONDITION

[adeel via OfficeKB.com]

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

 

[Guest]

=SUMPRODUCT(--(A1:A8="Pen")*(B1:B8))

 

[Don Guillett]

Look in the help index for SUMIF

 

[Guest]

=sumif(A1:A10, "Car")

 

[Guest]

=sumif(A2:a10, "Car", B2:b10)