Imaginary circular reference?

[DanWallace]

I'm getting a circular reference warning when I open up my spreadsheet. Formula Auditing error checking points me to a cell F9, but that cell just has =SUM(F5:F24). F5 and F24 are both empty cells. Has excel gone mad?

 

[Banana]

I don't think so.

You have a cell in F9 with a formula that basically says "sum everything between F5 to F24"... F9 happens to fall inside that range so it's definitely a circular reference.

 

[Kryst51]

That is summing F5 THROUGH F24 - hence the circular reference error.

 

[DanWallace]

Thanks guys! I'm dumb. You rule.

 

[MSAccessRookie]

I'm getting a circular reference warning when I open up my spreadsheet. Formula Auditing error checking points me to a cell F9, but that cell just has =SUM(F5:F24). F5 and F24 are both empty cells. Has excel gone mad?

It is my understanding that the statement =SUM(F5:F24) is intended to supply the sum of all of the cells in Column F between Row 5 and Row 24. You are trying to store the result in Column F / Row 9, which is inside of that Range, and I think this is what is causing your problem.

NOTE: Looks like I was too slow again, but at least I had the right answer.