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.