#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
See attached!
|
#3
|
|||
|
|||
Awesome! - thanks a ton for your help!
Awesome! - thanks a ton for your help!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
stop date calculation when a criteria is met | GG@Excel | Excel | 6 | 12-15-2018 04:38 AM |
Perform function when t-character is entered in Column-A | SerenityNetworks | Excel Programming | 3 | 12-22-2017 09:24 AM |
Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. | phillipsdp | Excel | 1 | 11-09-2016 12:53 AM |
Perform calc in active cell then highlight based on formula result | grexcelman | Excel Programming | 4 | 01-12-2015 11:00 AM |
Rules based due date calculation | dlowrey | Excel Programming | 3 | 05-12-2013 08:30 PM |