| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#REF! errors
Hello. When I add in a row or delete a row I get a #REF! error and instead of changing the resulting number in the sum cell, it provides the error. For example if I have a formula in cell C20 to be the sum of C12 to C19, if I remove C14, the new formula is not the sum of C12 to C19 minus C14 (as it was removed), yet rather #REF! shows up in several places, it should not.
Thanks EggHeadCafe - Software Developer Portal of Choice Play Embedded Sound Resources in .NET http://www.eggheadcafe.com/tutorials...und-resou.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #DIV/0! errors | Excel Worksheet Functions | |||
| Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
| IIf and value-errors | Excel Discussion (Misc queries) | |||
| sum errors | Excel Worksheet Functions | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
Threaded Mode
