Google Sheets Circular Formula Fix

You’re seeing a circular dependency error, your formula refers to itself directly or indirectly, so Google Sheets can’t calculate it.
This shows up as “Circular dependency detected” or a blank/error result.

Why the Issue Happens

• A formula references its own cell (direct loop)
• Two or more cells reference each other (indirect loop)
• Using running totals without a proper structure
• Copying formulas across rows without fixing references
• Using ARRAYFORMULA that includes its own output range

Step-by-Step Fixes

Step 1: Identify the Circular Reference

Click the error cell and trace references.
Example (direct loop):

A1 = A1 + 10   ❌

This will always cause a circular error.

Step 2: Fix Direct Self-Reference

Move the input to a different cell.

Wrong:

A1 = A1 + 10

Correct:

A1 = B1 + 10

Keep inputs and calculations separate.

Step 3: Fix Indirect Loops

Example:

A1 = B1 + 10  
B1 = A1 + 5   ❌

Fix by breaking the loop:

B1 = 5  
A1 = B1 + 10

Only one direction of dependency.

Step 4: Fix Running Total Formulas

Wrong (common mistake):

B2 = B1 + A2

This creates a circular issue when dragged.

Correct approach:

B2 = SUM($A$2:A2)

This avoids referencing the same column cumulatively.

Step 5: Fix ARRAYFORMULA Circular Issues

Wrong:

=ARRAYFORMULA(A2:A + B2:B)

Placed in column A or B → circular loop.

Fix:

• Place formula in a separate column (e.g., C)

=ARRAYFORMULA(A2:A + B2:B)

Step 6: Check Absolute vs Relative References

Wrong:

A2 = A2 + B2

Fix:

A2 = $A$1 + B2

Use fixed references where needed.

Step 7: Avoid Overlapping Output Ranges

If a formula writes into the same range it reads from, it creates a loop.

Fix:

• Use separate input and output ranges

Step 8: Use Helper Columns

Instead of one complex looped formula:

• Column A → raw data
• Column B → calculation
• Column C → final output

This removes circular dependencies.

Step 9: Enable Iterative Calculation (Only If Needed)

Go to:
File → Settings → Calculation

Enable:

• Iterative calculation

Use only for advanced cases like:

• Interest compounding
• Goal seek models

Not recommended for normal use.

Step 10: Rebuild Formula Logic

If circular error persists:

• Break formula into smaller parts
• Check dependencies step-by-step
• Ensure no cell depends on itself

Common Mistakes

• Referencing the same cell in its own formula
• Creating loops across multiple cells
• Using ARRAYFORMULA in the same column it references
• Dragging formulas without adjusting references
• Not separating inputs and outputs

Pro Tips

Use SUM for cumulative calculations:

=SUM($A$2:A2)

Use helper columns instead of nested logic

Keep formula flow one-directional:
Input → Process → Output

Bottom Line

Fix circular references in this order:

1. Identify where the loop starts
2. Remove self-referencing formulas
3. Break indirect dependencies
4. Use helper columns or SUM-based logic
5. Avoid overlapping ranges

Most circular errors come from bad formula structure, not complexity.
Fix the flow, and the error disappears.