Perform calculation on value above in the same column based on criteria
I'd like to know if its possible to perform a running calculation in a column to add a value in a cell to another value indirectly above it in the same column based on a value in another column?
Example: cell A102 has the value "PROO" and cell D102 has the value "835.00". Cell D103 and D104 have values >0. Cell D105 has a value -232 as does cells D107 and D017.
If the values are <0, then I need to calculate 835+-232 for a result of 603. This pattern continues on down the column but not always the same number of values and the values change of course. Is this possible to do?
|