All solutions SUM Expert Solution – Excel SUM Problems

Excel - SUM Function Problem - Expert Solution

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.

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc