# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I am creating a checkbook register, columnD is deposits, Column E is withdrawal, columnF is balance, how do i get a running total in the balance column
Solved by K. Q. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/02/2018 - 10:08
Welcome to excel got it pro.
Excelchat Expert 12/02/2018 - 10:08
Excelchat Expert 12/02/2018 - 10:10
My understanding is that, by running total you mean cumulative balance, right?
User 12/02/2018 - 10:10
right
Excelchat Expert 12/02/2018 - 10:11
I have wrote a formula in column F, would you please input some samples in column D and E and test the formula?
Excelchat Expert 12/02/2018 - 10:12
Is it alright?
User 12/02/2018 - 10:12
yes
Excelchat Expert 12/02/2018 - 10:14
you have the formulas?
User 12/02/2018 - 10:14
where are they?
Excelchat Expert 12/02/2018 - 10:14
this is for first row =D2-E2
Excelchat Expert 12/02/2018 - 10:15
From 2nd row use this =F2+D3-E3.
Excelchat Expert 12/02/2018 - 10:15
Excelchat Expert 12/02/2018 - 10:15
This is a copy of the preview file.
User 12/02/2018 - 10:16
Do I have to keep writing in a formula
Excelchat Expert 12/02/2018 - 10:16
You can drag the formula down.
Excelchat Expert 12/02/2018 - 10:17
Like this.
Excelchat Expert 12/02/2018 - 10:17
Do you want me to modify the formula so that when col D and E both are blank, F will also be blank?
User 12/02/2018 - 10:18
Can you show me how to drag it again
Excelchat Expert 12/02/2018 - 10:19
Sure.
Excelchat Expert 12/02/2018 - 10:21
So, when you select a cell in excel, do you see a rectangle at the bottom right corner of that cells border? move your mouse pointer over it, you will then see your mouse pointer making a plus sign, now hold it and drag it down.
User 12/02/2018 - 10:21
yes and ok
User 12/02/2018 - 10:22
So I won't have to keep writing a formula in the balance column
Excelchat Expert 12/02/2018 - 10:22
Yup.
Excelchat Expert 12/02/2018 - 10:22
That's true.
User 12/02/2018 - 10:23
Thanks now I hope it will work when I create my register
Excelchat Expert 12/02/2018 - 10:23
Excelchat Expert 12/02/2018 - 10:23
It sure will, please keep the file for reference.
Excelchat Expert 12/02/2018 - 10:24
Anything else you need?
User 12/02/2018 - 10:24
ok and thanke
Excelchat Expert 12/02/2018 - 10:24
If not please close the session and leave a feedback for me.
Excelchat Expert 12/02/2018 - 10:24
To close session click on the end session button.

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.