Sum Values Based on Categories in Different Column

Please help,

I have data in Excel like below:

Column A Column B
Asset Class Market Weight
Large Growth 5.5%
Large Value 6.9%
Large Growth 11.9%
Small Growth 3.3%
International 8.9%
Small Growth 1.1%

How do I create a formula or VBA code that will add up the total %'s for each asset class category? For example, I want the total (sum) % for all Large Growth listed?

Thanks

The function you want is SUMIF(). Press F1 in Excel to read up on it the builtin helpfiles.

Examples:
=SUMIF(A:A, "Large Growth", B:B)
=SUMIF($A$1:$A$100, D12, $B$1:$B$100) (where D12 has the text string "Large Growth")