Excel - COLUMN Function Problem - Expert Solution

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

For each row, I want to add the values in columns 3, 4 &5, and enter the result in column 6. I also want to calculate a running total of the values in column 6 for each row and enter the result in column 7.
Solved by G. B. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 27/09/2018 - 01:06
I have excel that produces documents endin .xlsx
Excelchat Expert 27/09/2018 - 01:06
Hi Welcome to Excelchat
Excelchat Expert 27/09/2018 - 01:07
Can you please share that excel file? The recent version of excel have .xlsx as file extension
Excelchat Expert 27/09/2018 - 01:08
Are there are any column headers?
Excelchat Expert 27/09/2018 - 01:09
Formula for sum will be =SUM(C2:E2)
Excelchat Expert 27/09/2018 - 01:09
You can put the above formula in cell F2
Excelchat Expert 27/09/2018 - 01:10
Should
Excelchat Expert 27/09/2018 - 01:10
*Shouldn't it be 320?
Excelchat Expert 27/09/2018 - 01:14
Are you there?
Excelchat Expert 27/09/2018 - 01:14
Can you tell me why did you make it 0?
User 27/09/2018 - 01:14
I have put these formulae in but the answers are not 0
Excelchat Expert 27/09/2018 - 01:15
It is happening because of Pound sign
Excelchat Expert 27/09/2018 - 01:16
Can you paste that formula in your excel and let me know?
User 27/09/2018 - 01:16
I want to work in GBP
Excelchat Expert 27/09/2018 - 01:16
Sure
Excelchat Expert 27/09/2018 - 01:16
It will work with excel. Seems some issue with Google Sheets
Excelchat Expert 27/09/2018 - 01:17
In your local excel, once you enter the numbers go to Home > Select "Currency" from Number menu
Excelchat Expert 27/09/2018 - 01:18
If you can share your excel file that would be great
User 27/09/2018 - 01:18
I can make the formula =SUM(C2:E2) work but do I have to type this formula each time into the column called "bal"?
Excelchat Expert 27/09/2018 - 01:18
No
Excelchat Expert 27/09/2018 - 01:19
If you hover your curson around the blue box (at bottom right) you can drag from there till the area where you need the formula
Excelchat Expert 27/09/2018 - 01:19
*cursor
User 27/09/2018 - 01:20
How do i put this formula in each row when the digits starting "2" increase each row down the page?
Excelchat Expert 27/09/2018 - 01:21
Sorry I didnt get you
User 27/09/2018 - 01:22
have put the formula in box F2.
Excelchat Expert 27/09/2018 - 01:23
Yes
Excelchat Expert 27/09/2018 - 01:23
Now you can copy that cell
User 27/09/2018 - 01:23
How do i continue down the page without having to change the row number/
Excelchat Expert 27/09/2018 - 01:23
Then select the cells where you want the same formula to apply i.e. sum of C D and E
Excelchat Expert 27/09/2018 - 01:23
Paste the formula in those cells
Excelchat Expert 27/09/2018 - 01:23
The row numbers will change automatically
User 27/09/2018 - 01:24
OK The bigger problem is how to get a running total incolumn G
Excelchat Expert 27/09/2018 - 01:25
Yes, so for that basically you need the sum of 111 and 209. In the second row, right?
Excelchat Expert 27/09/2018 - 01:25
So for that you can use =E3+F2
Excelchat Expert 27/09/2018 - 01:25
and when you do the same copy paste, the row numbers will automatically change
Excelchat Expert 27/09/2018 - 01:26
You can try pasting the formula in row 4
User 27/09/2018 - 01:27
Yes but Do I have to type this in for lots of rows?
Excelchat Expert 27/09/2018 - 01:27
No No
Excelchat Expert 27/09/2018 - 01:27
You can copy paste or drag and drop
Excelchat Expert 27/09/2018 - 01:28
By drag and drop I mean dragging the bottom right corner of the formula cell till the row you want it to appear
User 27/09/2018 - 01:29
Do the row numbers change automatically?
Excelchat Expert 27/09/2018 - 01:29
Yes :)
User 27/09/2018 - 01:29
I will try .Thanks I may have to ask you again!
Excelchat Expert 27/09/2018 - 01:30
Row numbers are dynamic unless specifically made static by adding $ sign before them. For e.g. D$2
Excelchat Expert 27/09/2018 - 01:30
Sure
Excelchat Expert 27/09/2018 - 01:30
Feel free to do so
Excelchat Expert 27/09/2018 - 01:30
Have a good day
User 27/09/2018 - 01:31
That is the most useful thing to know that the $ keep the number the same. Thank you. good bye.
Excelchat Expert 27/09/2018 - 01:31
:)
Excelchat Expert 27/09/2018 - 01:31
Glad I was helpful
Excelchat Expert 27/09/2018 - 01:31
You can leave the review/feedback after clicking on "End Session"

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
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc