# Excel - COLUMN Function Problem - Expert Solution

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

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.