moderated Re: MS EXCEL formula
toggle quoted messageShow quoted text
Robin, Thank you, your help did what was needed. I appreciate your help. To all who offered assistance, I do thank you all, as well.
From: firstname.lastname@example.org <email@example.com> On Behalf Of Van Lant, Robin via Groups.Io
Sent: Monday, January 13, 2020 10:46 AM
Subject: Re: MS EXCEL formula
I’ll give a crack at explaining this to build on what Anne was saying:
For simplicity in my mind, I’m going to approach this slightly different from Anne.
I am assuming that cell D14 has your first dollar amount to add to the running balance in Column E.
Step 1. Go to cell E14 and type “=D14”. This is just pulling in the value from column D into column E for this line item as the first item in your running balance.
Step 2: go down to Cell E15. This is the first place where you’ll be adding a new line item to your running balance. Your formula should be “=E14+D15”. This adds the value of the new line item to the balance listed in the cell above.
Step 3. Go to cell E16 and press Control+D , which will copy the above formula into this cell, adjusting the cell references as needed. You can do this same keystroke all the way down Column E to build that running balance.
There are other methods, but you seem to be a novice Excel user, so I’m leaving this simple.
From: firstname.lastname@example.org <email@example.com> On Behalf Of Rick Mladek
Is there a formula where the running balance/total can be in column E for example? Example: row 14 column D has $22.50 and this should be seen in same row 14 but column E. The next row, 15, has in column D $220.59 and row 15, column E should have the running total or sum. This would go down all rows and columns. Is this possible or just the total somewhere at the bottom cell where the total would be seen?
You can put the formula anywhere in column e that you want the total to be.
The formula should be =sum(d14:d100)
Equals sum tells excel that you want to add numbers together.
open parenthesis d14 colon d100 close parenthesis tells it to add d14 through d100.
"Reality is the leading cause of stress for those who are in touch with it."
-- from The Search for Signs of Intelligent Life in the Universe, by Jane Wagner