Excel 2007 - sum function not working

[IVCC]

My worksheet has several rows of data and I am trying to use the autosum tool
in the ribbon it is not consistant, sometimes it will calculate the sum and
other times it puts the formula in the where the sum should be. If I use the
copy function from one that worked and paste into one that didn't it
magically returns a result. Why won't the autosum work?

1) Some of your cells are formatted as text.
Some of these worksheets were created in Excel 2003 and the data
did not retain it's format when opened in Excel 2007. Is there something one
can do to a file in 2003 prior to opening in 2007 to make it retain it's
former data types?


2) You have calculation set to manual. In previous versions this could be
found at Tools>Options>Calculations Tab.

In Excel 2007 the default is Automatic

 

[Peo Sjoblom]

You can force text numbers by formatting an empty cell the way you want the
end result to be, copy it and then select all the numbers in question, do
edit>paste special and select add. Or select the column with the numbers and
do data>text to columns and click finish.

--


Regards,


Peo Sjoblom

 

[Gord Dibben]

The calc mode is governed by the mode of the first workbook opened during a
session of Excel.

So...........the default for a new workbook is automatic but might not stay that
way if you have earlier opened a book with calculation set to manual.

Your problem sounds like some cells are text and some numbers.

See Peo's reply for changing to numbers.


Gord Dibben MS Excel MVP