ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sum totaling doesnt work (https://www.excelbanter.com/excel-worksheet-functions/33942-sum-totaling-doesnt-work.html)

Bedros

sum totaling doesnt work
 
The "SUM" when I add a nunber of figures and use the "SUM" it will total but
if I add another number to it, it will not change the total sum. I've tried
every way and the total sum still doesn't change. It just doesn't add
automatically. I never had any problem with WINDOWS 98. Now I'musing
WINDOWS XP.

What am I doing wrong?

ScottO

Is Calculation currently set to Manual? If so, after changing a cell you'll see "Calculate" in the
Status Bar.
Try hitting F9 and see if your Sum changes.
If it does, go Tools/Options go to the Calculation Tab and set to Automatic.
Rgds,
ScottO

"Bedros" wrote in message
...
| The "SUM" when I add a nunber of figures and use the "SUM" it will total but
| if I add another number to it, it will not change the total sum. I've tried
| every way and the total sum still doesn't change. It just doesn't add
| automatically. I never had any problem with WINDOWS 98. Now I'musing
| WINDOWS XP.
|
| What am I doing wrong?




All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com