Circular Reference Won't Go Away

Hi,

I'm working on fairly large sheets that reference many other sheets. My main summary sheet is doing SUMIFS formulas to summarize and sum to a higher level. The summary sheet column is showing a Circular Reference error. I found the error on my raw sheet and corrected. However the main summary file still shows a circular reference error that won't go away even after re-doing the reference and formula. Again, the sheet it is referencing does not show an error in the column I am summing. Any advice?

Thanks,

Liz

Find more posts tagged with

Formulas

Support

Comments

Mike Wilday

Could you provide a screenshot for us to see what is going on while hiding any sensitive information?

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.