Excel 2007 : Count total quantity in a table

Dear All,

Please find attched table. All the fruit names are in column A and the quantity in column B. .Kindly advise how can i get the total quantity of each fruit in that table at in column G.

Thanks in advance for the support.
Regards,

try =SUMIF($B$2:$B$10,"apple",$C$2:$C$10) and adapt for other fruit

Alternatively a Pivot Table might help

Thanks a lot.

Regards.