Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula to do a running total in a column of my excel spreadsheet
Solved by C. H. in 24 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/09/2018 - 08:56
Hello, welcome to got it pro.
Excelchat Expert
05/09/2018 - 08:56
We are delighted to have you here with us.
Excelchat Expert
05/09/2018 - 08:56
I believe you want help with a running total, right?
User
05/09/2018 - 08:56
yes
Excelchat Expert
05/09/2018 - 08:57
Please tell me details along with the data.
User
05/09/2018 - 08:58
I want to get a running total of positive and negative amounts on a spreadsheet
Excelchat Expert
05/09/2018 - 08:58
That's great. But to clearly understand the problem, I need to see what you meant by " positive and negative amounts", can you show me your file?
User
05/09/2018 - 09:00
Can I type an example in the blanks XLSX
Excelchat Expert
05/09/2018 - 09:01
Sure, that would be great.
Excelchat Expert
05/09/2018 - 09:01
Please go ahead.
User
05/09/2018 - 09:03
I have typed in particulars
Excelchat Expert
05/09/2018 - 09:03
Okay, now please describe what you need.
User
05/09/2018 - 09:04
To have a running total in colum D of entries in C
Excelchat Expert
05/09/2018 - 09:04
You said something about negative and positive amount.
User
05/09/2018 - 09:05
Yes I need monies in to be deducted
User
05/09/2018 - 09:06
~Please see amended spreadsheet. Thank you
Excelchat Expert
05/09/2018 - 09:08
Which one is negative and which one is positive again?
Excelchat Expert
05/09/2018 - 09:08
I need to know just to make sure I got the clear idea.
User
05/09/2018 - 09:09
The rent is the one that has to be deducted from the running total
Excelchat Expert
05/09/2018 - 09:09
So everything that goes to In column is negative, right?
User
05/09/2018 - 09:11
The money out is negative because I have not yet got that money. The rent will be positive
User
05/09/2018 - 09:11
So the 1052.30 is negative then the rent is added but number will still be negative
Excelchat Expert
05/09/2018 - 09:12
Sorry, In order to write a formula I need to know every details. I know you think it should be straight forward for an excel expert, but we solve different kind of problems and each problem is different for each individuals.
User
05/09/2018 - 09:13
What you have done is correct
Excelchat Expert
05/09/2018 - 09:13
SO, what I need you to is, manually filling in column E with running total, then I will write the formula accordingly in column F>
User
05/09/2018 - 09:16
have done that hank you
Excelchat Expert
05/09/2018 - 09:17
The first cell formula in F2 is =D2-C2
Excelchat Expert
05/09/2018 - 09:17
From F3 use this formula =F2+D3-C3 and drag it down for running total.
User
05/09/2018 - 09:18
Many thanks
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.