|
|
#1
01-13-2020, 01:41 PM
|
|||
|
|||
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
01-14-2020, 12:08 AM
|
|||
|
|||
|
See attached!
|
|
|
|
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 |
Windows 10 
Office 2013
Linear Mode
