| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Interesting Formula Problem
Hi Folks - Interesting issue in Excel ... I have a sheet that looks like
this: Jan Feb Mar Total Rent 1000 1000 1000 3000 Utilities 500 500 500 1500 The Total column is calculated with the sum function. If I insert a column to the left of the totals columns, then enter manually 1000 for Rent, the formula recalculates to include the new column. Perfect! However, if I "fill" the 1000 from the Mar column to the new column, the formula does not recalculate. Odd! Any ideas why? Thanks. -- Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Very interesting problem that should be a snap to figure out! | Excel Discussion (Misc queries) | |||
| Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
| Interesting Workbook formula problem | Excel Worksheet Functions | |||
| interesting question can anyone help | Excel Discussion (Misc queries) | |||
| Interesting TIF file problem | Excel Discussion (Misc queries) | |||
Threaded Mode
