Excel Help with statement function

i am trying to create a statement where it searches a column for a certain "value" and then returns the "sum" of another column.

example:
column 1: column 2: column 3
row 1: Stock: 20
row 2: Option: 10
row 3: stock: 5

so say i want to find the value of all "stock" in column 2 and return the sum of column 3 that equals "stock. the ending result is 25.

i am positive it's possible but can't figure out the statement.

 

To make column4 into a running sum of the "stock" values,

IF(column2 of my row holds the word "stock")
THEN(my column4 = (the column4 in the row above me) + (the column3 in my row))
OTHERWISE(my column4 = (the column4 in the row above me))

 

appreciate the suggestion. is there a way to do it without making column 4?

for example, I just want the total without making a new column, instead just placing it in the same column at the end as a total.

i have been trying various functions like if, vlookup, and lookup but can't seem to get them to work.

 

SDacct,

See attachment for extended example.

Grant.

 

Thanks for the help Grant. It worked perfectly.

Out of all the functions, I can't believe I didn't try SUMIF.

 

SDacct,

My pleasure.

Grant.