help with totalling a column based on value in previous column

[JenA510]

So here is what I need help with... I have a spreadsheet I am creating and want a cell at the bottom to search for a term in cells b2:b100 and if it equals one term to return the numerical value in column c. I also want it to keep a running total of these values so for example it would read

B/ C
Renawal/New Sub/ Price
Renewal/ $5.00
Renewal/ $10.00
Renewal/ $20.00
New Sub/ $15.00


Total Renewal Dollars: ????? <---the total I am looking for. So in column "B" it would find all columns with renewal and add up their "C" values.

I tried vlookup and "if" statements and can only get them to return the value from C2.

Thanks for any and all help!!!!

[NBVC]

Try SUMIF

e.g.

=SUMIF(A1:A10,"Renewal",B1:B10)

this sums B1:B10 where A1:A10 contain word Renewal.

[JenA510]

Try SUMIF

e.g.

=SUMIF(A1:A10,"Renewal",B1:B10)

this sums B1:B10 where A1:A10 contain word Renewal.

This worked like a charm! THANK YOU!!!!!!!!!!!!!!!!! YOU ROCK!