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