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