Microsoft Office Forums Adding adjacent cells and having the sum appear in two separate places

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-10-2016, 07:21 PM
Seamus Sean Seamus Sean is offline Adding adjacent cells and having the sum appear in two separate places Windows 10 Adding adjacent cells and having the sum appear in two separate places Office 2016
Novice
Adding adjacent cells and having the sum appear in two separate places
 
Join Date: Dec 2016
Posts: 3
Seamus Sean is on a distinguished road
Default Adding adjacent cells and having the sum appear in two separate places


In the example, I'd like to keep a record of expenses. I'd like to apply the same formula of adding the amounts in two cells and having their sum appear in two separate places. I'd like to format about 50 rows to follow this. I'd like the cells to remain blank until an amount is entered in them to be added.
Attached Images
File Type: jpg Sums automatically appearing.jpg (30.7 KB, 7 views)

Last edited by Seamus Sean; 12-10-2016 at 10:16 PM.
Reply With Quote
  #2  
Old 12-11-2016, 01:24 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Adding adjacent cells and having the sum appear in two separate places Windows 7 64bit Adding adjacent cells and having the sum appear in two separate places Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hi and welcome
if the sum appears in A3, you will not be able to enter data there in the future without the formula disappearing
What are you trying to do exactly ?
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #3  
Old 12-11-2016, 02:10 AM
Mr.Onion Mr.Onion is offline Adding adjacent cells and having the sum appear in two separate places Windows 10 Adding adjacent cells and having the sum appear in two separate places Office 2010 64bit
Novice
 
Join Date: Dec 2016
Posts: 3
Mr.Onion is on a distinguished road
Default

You can do this:
C2 = IF(OR(A2="",B2=""),"",SUM(A2:B2))

A3 = IF(C2="","",C2)

then you just copy the formula down.

P.S. I would personally avoid using IF for trivial condition like that since it can get messy when you nest an IF inside another IF, but this one seems simple enough.
Reply With Quote
  #4  
Old 12-11-2016, 06:46 PM
Seamus Sean Seamus Sean is offline Adding adjacent cells and having the sum appear in two separate places Windows 10 Adding adjacent cells and having the sum appear in two separate places Office 2016
Novice
Adding adjacent cells and having the sum appear in two separate places
 
Join Date: Dec 2016
Posts: 3
Seamus Sean is on a distinguished road
Default

Thanks for your reply. This exercise is to determine a way to do a simple horizontal addition problem where, for example, a current expense would be entered in cell B2 that would be added to the previous total expenditures which would be located in A2. We'd like the sum of the two to automatically appear in cell C3, by simply tabbing into it. We'd also like that total to also automatically appear in cell A3 where it would become the new "total expenditure", and it would be added to the next expense....and so on.
Reply With Quote
  #5  
Old 12-11-2016, 10:34 PM
Seamus Sean Seamus Sean is offline Adding adjacent cells and having the sum appear in two separate places Windows 10 Adding adjacent cells and having the sum appear in two separate places Office 2016
Novice
Adding adjacent cells and having the sum appear in two separate places
 
Join Date: Dec 2016
Posts: 3
Seamus Sean is on a distinguished road
Default

Thanks Mr. Onion. That accomplished what we were trying to do! It might take a while to digest what you've suggested, but now we have a place to start.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using alternating borders in adjacent cells jrevard Word 0 10-15-2015 09:07 AM
How do I separate an address into separate cells Austcart Excel 2 01-18-2015 03:48 PM
Adding adjacent cells and having the sum appear in two separate places How to conditionally format cells in Col. A if it matches adjacent cell in Col. B? alshcover Excel 2 06-03-2014 12:50 PM
Adding adjacent cells and having the sum appear in two separate places Word Macro to find and delete rows that contain adjacent cells containing "." AlexanderJohnWilley Word VBA 7 11-08-2012 10:15 AM
How to "hard link" two adjacent cells to a data validation drop down list? Geza59 Excel 10 10-19-2012 11:56 AM


All times are GMT -7. The time now is 06:27 AM.


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