Circular reference, Indirect, and Sum

[cmrandom22]

Hello everyone,

Excel complains of an error every time I open up a worksheet, saying
that there is a circular reference.

My worksheet contains numbers in L18, L19, L20, L21. The formula in
L22 is: =SUM(INDIRECT("l18:L20")) . This outputs and adds the cells
correctly, but excel says there is a circular reference in L22. How do
I fix the circular reference warning?

Thanks in advance,
cmrandom22

 

[Pete_UK]

Why do you need the INDIRECT to be there? Can't you just do:

=SUM(L18:L20)

?

Hope this helps.

Pete

 

[cmrandom22]

Why do you need the INDIRECT to be there? Can't you just do:

=SUM(L18:L20)

?

The real 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've narrowed down the circular reference issue to: SUM(INDIRECT
("A1:A2")), and this formula is located in cell A3.

cmrandom22

 

[Bernard Liengme]

I have your formula SUM(INDIRECT("A1:A2")) in A3 with no problem
Maybe we need a bit more info on the worksheet layout and location of the
actual formula
best wishes