#1
|
|||
|
|||
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. Last edited by Seamus Sean; 12-10-2016 at 10:16 PM. |
#2
|
||||
|
||||
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 ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
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 |
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 |
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 |