I have an existing spreadsheet that contains a very simple sum formula at the
end of each column. It has always worked until recently. Now when I add
data it is not autmatically summed at the bottom of the column. To get the
amount added in I have to click on the cell with the formula, click the end
of the formula and hit enter. I checked the formula and it includes all
cells in the columns. Any idea what is happening to such a simple function?

Check to make sure Automatic Calculations are turned on.

Tools -- Options -- Calculation Tab -- Check "Automatic"

HTH,
Elkar


"CBP" wrote:

I have an existing spreadsheet that contains a very simple sum formula at the
end of each column. It has always worked until recently. Now when I add
data it is not autmatically summed at the bottom of the column. To get the
amount added in I have to click on the cell with the formula, click the end
of the formula and hit enter. I checked the formula and it includes all
cells in the columns. Any idea what is happening to such a simple function?