Excel Help with statement function

S

SDacct

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.
 
You must log in or register to reply here.
Back
Top