Check ToolsOptionsCalculation tab; is calculation set to Automatic?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Carol" wrote in message ...
|I have a spreadsheet that I need to keep adding to and when I put in more
| figures it does not add them into totals even though the sum range is correct
| has anyone any idess