| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Columns - Formula Results turn to #REF!
I am trying to pull information from a schedule and am running into a
problem. The person updating the schedule deletes the previous week and my formula result changes to #REF!. Is there an easy way to fix this. I had fixed this using a Macro but he added rows and my Macro got messed up. The formula I am using is =SUM(MANPOWER!F49:I49). Thank you, Havenstar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Array formula returning wrong results | Excel Discussion (Misc queries) | |||
| how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
Threaded Mode
