Go Back   Cyber Tech Help Support Forums > Software > Applications


Topic Tools
Old February 1st, 2018, 05:26 AM
Windrider Windrider is offline
Senior Member
Join Date: Oct 2011
Posts: 208
Excel and Circular Reference

I am using Excell 2007 on a Win 10 computer. When I attempt to select a column of numbers, selected Auto Sum and hit enter I get a Circular Reference error. I turned off all the Excel rules but still got the error message. Also entered the formula manually with the same message.
Reply With Quote

Old February 1st, 2018, 05:49 AM
smurfy's Avatar
smurfy smurfy is offline
Cyber Tech Help Moderator
Join Date: Sep 2000
O/S: Linux
Location: Christchurch New Zealand
Posts: 9,509
Check each cell you are summing up. One of them may include a formula that includes the cell you are placing your AutoSum in.
A1 = 10
A2 = 20
A3 = 30
A3 = 40
A4 = SUM(A1:A3)
A5 = SUM(A2:A4)
A6 = SUM(A3:A5)
A7 = A6+A8
A8 = SUM(A1:A7)

Because A7 formula includes value of A8, A8 formula can't use value of A7.
Reply With Quote


Topic Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT +1. The time now is 05:06 PM.