Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Circular reference, Indirect, and Sum
Hello everyone,
Every time I open an excel worksheet, I get an error complaining about circular reference. The code I'm using is: =SUM(INDIRECT("H10:"&ADDRESS(ROW ()-1,8))) ,which says: Add the rows starting from H10 to the position at row above current cell, column #8. I can simplify the formula and still reproduce a circular reference warning by having the formula: SUM(INDIRECT ("A1:A2")), and this formula is located in cell A3. How do I fix this error? cmrandom22 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular reference help | Excel Discussion (Misc queries) | |||
Circular Reference - Why? | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Discussion (Misc queries) | |||
Help on Circular Reference, | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Discussion (Misc queries) |