Circular Dependency in Google Sheets
What it means: A formula refers back to its own cell, creating a loop Sheets can't resolve.
Quick fix
=SUM(A2:A9)
Make sure a total sums the rows above it, not the range that includes the total cell itself.
Why you see Circular — and how to fix each cause
1. A total that includes its own cell
If A10 holds =SUM(A1:A10), it tries to add itself — a loop.
Fix: Exclude the formula cell from its own range.
=SUM(A1:A9)
2. Two cells that reference each other
A1 = =B1+1 and B1 = =A1+1 depend on each other endlessly.
Fix: Break the chain — base one cell on a fixed value or a different source.
3. Intentional iterative calc without iteration turned on
Some running-balance patterns are circular by design but need iterative calculation enabled.
Fix: Enable File → Settings → Calculation → Iterative calculation, and set max iterations.
Before and after
| Broken | Working |
|---|---|
A10: =SUM(A1:A10) |
A10: =SUM(A1:A9) |
The total cell must not be inside the range it totals.
How to stop it happening again
Keep totals outside the range they summarize and avoid two cells pointing at each other. If you genuinely need a self-referencing calculation, turn on iterative calculation deliberately under File → Settings rather than by accident.
FAQ
How do I find which cell is circular?
The error message names a cell reference. Start there and trace each reference it points to until you find the loop.
Is a circular dependency ever okay?
Only when you deliberately enable iterative calculation for models like running balances. Otherwise it's a mistake to fix.
→ Google Sheets formulas cheat sheet — 34 copy-paste formulas