I need to have a total cell for a large spreadsheet I'm working on (150+lines
of data).  I need to put in a formula that will add the amount in Column B if
the word in the Column A says "Retail".

Example:
A                     B
Retail           10,950
Storage         6,500
Retail             5,000
Retail             4,000
Storage          3,500

Total Retail      Amount
Total Storage   Amount

Relatively new to Excel, so any help would be greatly appreciated!!!