Sumif question

[txbullets]

I am trying to figure out a formula that will look in a particular column for a word and then return the sum of all values associated with that particular word. I know an easy way to do this would be a lookup table but was wondering if there is a formula for this as well because the table is locked and I just need to pull some numbers for it

Example

____A ___________B

Expansion_______$1,000
Expansion_______$5,000
Repair__________$2,500
Expansion_______$8,500
Repair__________$1,900

So I want to sum all expansion cost and all repair cost, ect.

Thanks in advace

JZ

[VBA Noob]

Try sumif

e.g

=SUMIF(A:A,"Repair",B:B)

VBA Noob

[WinteE]

Use SUMIF()

[txbullets]

Works perfect. I knew it would be an easy one I am just very new to formulas and did not have a lot of time to research it. Thank you for your help

[VBA Noob]

Glad you found a solution

VBA Noob