Question description:
This user has given permission to use the problem statement for this
blog.
Adding multiple columns and have it adjust the addition as i change the amounts in each column
Solved by O. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/05/2018 - 01:50
Hello
Welcome to Gotit pro,
your problem will be higly answered
here. May I ask how may I help you?
User
02/05/2018 - 01:50
I want to add multiple columns. Which i have been doing. Before as i change the value of each column excel would do the addition automatically. Now it does not.
Excelchat Expert
02/05/2018 - 01:51
do you have your data?
Excelchat Expert
02/05/2018 - 01:51
so we can easily analyze the problem
User
02/05/2018 - 01:51
just put in an example
Excelchat Expert
02/05/2018 - 01:51
ok then?
Excelchat Expert
02/05/2018 - 01:52
where do you want to add column?
User
02/05/2018 - 01:53
I want to add each row and the total
User
02/05/2018 - 01:54
So i have the Column A. Its the order column
Excelchat Expert
02/05/2018 - 01:54
ok,
User
02/05/2018 - 01:54
As people pay I transfer that amount to Cash, Check or CC column
Excelchat Expert
02/05/2018 - 01:54
we just need to sum each row right?
User
02/05/2018 - 01:54
Numbers always changing from column to column and im always adding new order.
User
02/05/2018 - 01:54
Yes
Excelchat Expert
02/05/2018 - 01:55
ok
Excelchat Expert
02/05/2018 - 01:55
the weekly column?
Excelchat Expert
02/05/2018 - 01:55
is it where you want the formula be inputted?
User
02/05/2018 - 01:55
But now when i move the amount from order column to say cash column it does not auto add for me. I have to do the sum again and again.
User
02/05/2018 - 01:56
Also add each column
User
02/05/2018 - 01:56
Then a total at the bottom right under weekly.
Excelchat Expert
02/05/2018 - 01:56
ok
Excelchat Expert
02/05/2018 - 01:56
like that right?
User
02/05/2018 - 01:57
ok. That then you can erase all the weekly except for the total at the bottom.
User
02/05/2018 - 01:57
Keep 4950
Excelchat Expert
02/05/2018 - 01:57
ok
Excelchat Expert
02/05/2018 - 01:57
here you go
User
02/05/2018 - 01:57
Now add say $10 to any column
User
02/05/2018 - 01:58
It should auto add correct?
Excelchat Expert
02/05/2018 - 01:58
ok
Excelchat Expert
02/05/2018 - 01:58
yes
User
02/05/2018 - 01:58
Now my excel will not do tha
Excelchat Expert
02/05/2018 - 01:58
it was added
User
02/05/2018 - 01:58
Mine does not?
User
02/05/2018 - 01:58
What am i doing wrong?
Excelchat Expert
02/05/2018 - 01:58
i think, your excel was on manual mode
Excelchat Expert
02/05/2018 - 01:58
you may change it into automatic
User
02/05/2018 - 01:59
How do i go back to auto
Excelchat Expert
02/05/2018 - 01:59
just click the option
User
02/05/2018 - 01:59
Where is that?
Excelchat Expert
02/05/2018 - 01:59
click file>option
Excelchat Expert
02/05/2018 - 02:00
have you seen it?
User
02/05/2018 - 02:00
God. THANK YOU
User
02/05/2018 - 02:00
I have been going crazy
Excelchat Expert
02/05/2018 - 02:00
have you change it to automatic now?
User
02/05/2018 - 02:00
Fixed. Some how it changed to manual
User
02/05/2018 - 02:00
Yes. THANK YOU
Excelchat Expert
02/05/2018 - 02:00
great :)
Excelchat Expert
02/05/2018 - 02:00
Is there anything else you want to know regarding this issue?
User
02/05/2018 - 02:01
Nope .. Looks Great
Excelchat Expert
02/05/2018 - 02:01
good :)
Excelchat Expert
02/05/2018 - 02:01
Thanks for using Got It Pro. Please give your kind feedback for our service.
On your window, kindly don't just close the window, there is an end button there so you could end the
session properly & message will appear to ask for the feedback :) Have a good day ahead ^_^
User
02/05/2018 - 02:01
I will. Thank You!!!
Excelchat Expert
02/05/2018 - 02:01
babye :)
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.