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

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

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

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