Circular reference, Indirect, and Sum

  • Thread starter Thread starter cmrandom22
  • Start date Start date
C

cmrandom22

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
 
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.
 
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
 
View > Toolbars > Customize > Circular Reference > Close. Then, click the
down arrow in the little rectangle area.

HTH,
Ryan---
 
Back
Top