Excel Help with statement function

Discussion in 'Trading Software' started by SDacct, Feb 2, 2008.

  1. SDacct

    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.
     
  2. MGJ

    MGJ

    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))
     
  3. SDacct

    SDacct

    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.
     
  4. Grant

    Grant

    SDacct,

    See attachment for extended example.

    Grant.
     
    • et.xls
      File size:
      13.5 KB
      Views:
      144
  5. SDacct

    SDacct

    Thanks for the help Grant. It worked perfectly.

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

    Grant

    SDacct,

    My pleasure.

    Grant.