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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Circular reference, Indirect, and Sum
The formula =SUM(INDIRECT("A1:A2")) in cell A3 does not give a circular
reference, so your fault is presumably elsewhere in the sheet. If you type "circular reference" into Excel help, you'll see a topic "Allow or correct a circular reference". It'll show you how to find where your problem occurs. -- David Biddulph "cmrandom22" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Circular reference, Indirect, and Sum
Hi,
for your second example I guess is another formula somewhere in your spreadsheet. when you receive the warning, click in details and see which formula is causing problems, another way is click in trace precedents or error checking "cmrandom22" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Circular reference, Indirect, and Sum
View Toolbars Customize Circular Reference Close. Then, click the
down arrow in the little rectangle area. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Eduardo" wrote: Hi, for your second example I guess is another formula somewhere in your spreadsheet. when you receive the warning, click in details and see which formula is causing problems, another way is click in trace precedents or error checking "cmrandom22" wrote: 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 |
Reply |
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) |