Microsoft Office Forums Adding adjacent cells and having the sum appear in two separate places
 Register FAQ Search Today's Posts Mark Forums Read

#1
12-10-2016, 07:21 PM
 Seamus Sean Windows 10 Office 2016 Novice Join Date: Dec 2016 Posts: 3
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
 Sums automatically appearing.jpg (30.7 KB, 7 views)

Last edited by Seamus Sean; 12-10-2016 at 10:16 PM.
#2
12-11-2016, 01:24 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,411

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 ?
#3
12-11-2016, 02:10 AM
 Mr.Onion Windows 10 Office 2010 64bit Novice Join Date: Dec 2016 Posts: 3

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.
#4
12-11-2016, 06:46 PM
 Seamus Sean Windows 10 Office 2016 Novice Join Date: Dec 2016 Posts: 3

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.
#5
12-11-2016, 10:34 PM
 Seamus Sean Windows 10 Office 2016 Novice Join Date: Dec 2016 Posts: 3

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.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post jrevard Word 0 10-15-2015 09:07 AM Austcart Excel 2 01-18-2015 03:48 PM alshcover Excel 2 06-03-2014 12:50 PM AlexanderJohnWilley Word VBA 7 11-08-2012 10:15 AM Geza59 Excel 10 10-19-2012 11:56 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:39 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top