| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Sum Function
We have an Excel 2002 spreadsheet where we are using the AutoSum Function to
total an entire column. Currently, the function "=SUM(F2:F99)" is in Cell F101 and Row 100 is empty. When we inserting a new row into the empty row of this spreadsheet, the function does not automatically update. "Options: Calculation" is set to Automatic. If we change the function to "=SUM(F2:F100)", will that fix the problem? If not, any other suggestions? Thanks in advance for the help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why will my function not work? it is just auto sum. | Excel Worksheet Functions | |||
| Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
| The auto fit row height function | Excel Discussion (Misc queries) | |||
| Function for Auto Populate | Excel Worksheet Functions | |||
| Auto sum Function | Excel Worksheet Functions | |||
Threaded Mode
