Problems with adding on spreadsheet

C

Carol

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
 
N

Niek Otten

Check Tools>Options>Calculation tab; is calculation set to Automatic?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 
G

Gord Dibben

Carol

In addition to checking auto-calc settings is it possible that you are entering
numbers in cells that are pre-formatted as text?


Gord Dibben MS Excel MVP
 
Top