SUM Function on Excel Document

Asked By mdabon 0 points N/A Posted on - 08/28/2011

I have this problem encountered on Microsoft Excel.  Everytime I input a figure for summation, the cell is not returning a value.  What it returns is the same value of previous data.  The SUM function only works when I click on the SAVE button.

Is there any way this can be corrected?

• Status: Open
• Question Views: 937
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by SolomonGrundy

Go To Solution

Answered By mykilua2000 0 points N/A #119549

SUM Function on Excel Document

You may have done my foregoing instructions but just read through them, you might have missed something.

• Click on the cell for the sum to appear, locate and click on the auto-sum icon located somewhere above the spreadsheet area.
• After that, drag and drop for the range of the cells to be added. The range is surrounded by marching ants.
• Double check for the accuracy of the data in range if ever there is no error, then press enter. 

  Just make sure the data in range do not contain text and/or letters for this will give an error to the provided sum.

About mykilua2000

Questions
1

Answers
48

Best Answers
15

• Vote Up 0 Vote Down

• Posted on - 08/28/2011
• Question Category: MS Excel

Best Answer

Best Answer

Answered By SolomonGrundy 0 points N/A #119550

SUM Function on Excel Document

Hello Mdabon.

Set workbook calculation to "automatic". 

How?

• From Microsoft Excel, go to Tools -> Options… -> click on "Calculation" tab. 
• Under the "Calculation" section, make sure that the radio button for "Automatic" is enabled.

The screenshot below is for Excel 2010.  But the basic procedure remains the same for all past and present versions of Microsoft Office.

Automatic calculation is what you supposed to use. That is, Excel performs calculation immediately after a variable in the formula changes. Your settings probably changed because the Excel file that you are editing was saved from a computer whose Excel was not set to automatic calculation.

Hope this helps!

About SolomonGrundy

Questions
0

Answers
20

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 08/28/2011
• Question Category: MS Excel