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.