| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL2000 trouble with SUM function recalculating on new data ent
I have a Sum function at the end of each row. When I enter the new monthly
number, it doesn't recalculate. F9 has no effect. If I change Sum (B1:m1) to =B1+C1+D1... it calculates correctly. I checked the data type to be Number, 0 Decimals for all cells. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Importing External Data function | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
Threaded Mode
