Thank you - that was what I needed!

"Peo Sjoblom" wrote:

=SUMIF(A1:A100,"Retail",B1:B100)



--


Regards,


Peo Sjoblom


"Maggie0507" wrote in message
...
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!!!