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