Forum Discussion
SUM formula doesn't work (Summing range calculated by INDIRECT formula)
Hello guys, I have dynamic list of SheetNames. Then I have couple of columns where I for each sheet calculate certain formula with INDIRECT function inside of it to refer to a sheet. Like this:...
So I fixed by enabling the Iterative Calculations:
Inspired by this article: https://support.microsoft.com/en-us/office/remove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123
I did test for Circular references but it seems greyed out in that sheet:
