| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with adding on spreadsheet
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems with adding on spreadsheet
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems with adding on spreadsheet
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 On Tue, 31 Oct 2006 03:33:01 -0800, Carol wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
| hyperlink problems with multiple sheet spreadsheet on Intranet | Excel Discussion (Misc queries) | |||
| Adding drop-down list to spreadsheet | Excel Discussion (Misc queries) | |||
| cumulative adding and dividing problems! | Excel Discussion (Misc queries) | |||
| Adding a button to a spreadsheet... | Excel Discussion (Misc queries) | |||
Linear Mode
