formula to find out total quantity of the item in a data

[learning_grexcel]

I have data similar to the following.
ice cream 50
apple 20
orange 30
ice cream 35
apple 15

Now I'm looking for a formula which will find out automatically how many total quantity of ice cream in that table, how many orange in that table, how many apple in that table etc.

Right now I filter and take the total of each item but it takes lot of time because the data is too huge.

 

[VoG]

Pivot Table or

=SUMIF(A1:A10,"ice cream",B1:B10)

 

[learning_grexcel]

it's awesome. Thanks a lot

 

[learning_grexcel]

I have been facing one issue with this formula. I hope you can sort it out.
When I put the formula to find out total of any item say ice cream it calculates total in each row with ice cream. But I want it to calculate only once and it should delete the duplicates. How it can be done?

I tried "Remove duplicates" option in Excel, but it doesn't work well.

 

[VoG]

Try like this - formula in C1 copied down

Excel Workbook
	A	B	C
1	x	3	21
2	ice cream	2	28
3	x	7
4	ice cream	10
5	ice cream	7
6	x	5
7	x	6
8	ice cream	9
9	y	8	8
10	z	5	5
Sheet1