Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-13-2020, 01:41 PM
DJ0691 DJ0691 is offline Perform calculation on value above in the same column based on criteria Windows 10 Perform calculation on value above in the same column based on criteria Office 2013
Novice
Perform calculation on value above in the same column based on criteria
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default 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?
Attached Images
File Type: jpg Example_Excel.jpg (167.1 KB, 14 views)
Reply With Quote
  #2  
Old 01-14-2020, 12:08 AM
ArviLaanemets ArviLaanemets is offline Perform calculation on value above in the same column based on criteria Windows 8 Perform calculation on value above in the same column based on criteria Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

See attached!
Attached Files
File Type: xlsx CalculationExample.xlsx (11.3 KB, 6 views)
Reply With Quote
  #3  
Old 01-14-2020, 06:20 AM
DJ0691 DJ0691 is offline Perform calculation on value above in the same column based on criteria Windows 10 Perform calculation on value above in the same column based on criteria Office 2013
Novice
Perform calculation on value above in the same column based on criteria
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default Awesome! - thanks a ton for your help!

Awesome! - thanks a ton for your help!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Perform calculation on value above in the same column based on criteria 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
Perform calculation on value above in the same column based on criteria 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
Perform calculation on value above in the same column based on criteria Rules based due date calculation dlowrey Excel Programming 3 05-12-2013 08:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft