**Question description:**

*This user has given permission to use the problem statement for this
blog.*

Hello I am trying to use Auto sum .
After I total up some cells, When I go to change one cell it does not total up automatically. I have to reuse auto sum every time I make a change.
Do you know how I can fix that?

Solved by T. W. in 11 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
10/04/2018 - 06:59

Hi there

User
10/04/2018 - 06:59

Hi

Excelchat Expert
10/04/2018 - 06:59

How are you and how may i assist you with today?

User
10/04/2018 - 06:59

Well Thanks,

Excelchat Expert
10/04/2018 - 07:00

So tell me how can i help you?

User
10/04/2018 - 07:00

I am trying to use Auto Sum, When reenter a number in a cell it does not add automatically,

User
10/04/2018 - 07:01

I have to reuse auto sum every time i make a change.

Excelchat Expert
10/04/2018 - 07:01

okay

Excelchat Expert
10/04/2018 - 07:01

i will try my best to help you out with this

User
10/04/2018 - 07:02

Thanks

Excelchat Expert
10/04/2018 - 07:02

Can you show me how you do that, in the shared sheet

User
10/04/2018 - 07:03

Like that. Here it works.

Excelchat Expert
10/04/2018 - 07:04

Now write anywhere in column D and E

Excelchat Expert
10/04/2018 - 07:04

sorry D and C

Excelchat Expert
10/04/2018 - 07:05

is it nice

User
10/04/2018 - 07:05

Yes here and now it works. But in my excel it does not.

Excelchat Expert
10/04/2018 - 07:06

see the formula there in B6

Excelchat Expert
10/04/2018 - 07:06

made some changes

Excelchat Expert
10/04/2018 - 07:06

This should work

Excelchat Expert
10/04/2018 - 07:06

:)

Excelchat Expert
10/04/2018 - 07:07

is it nice

User
10/04/2018 - 07:07

Yes, But on another file on my computer it does not work and I trying the same thing.

Excelchat Expert
10/04/2018 - 07:08

can you show me the formula youare using there?

User
10/04/2018 - 07:09

I copied and pasted. Now it works.

Excelchat Expert
10/04/2018 - 07:09

Yes, :)

Excelchat Expert
10/04/2018 - 07:09

Please do a valuable rating for me

Excelchat Expert
10/04/2018 - 07:10

that will help me a lot

User
10/04/2018 - 07:10

OK thanks.

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