Excel - COLUMN Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc