Forum Discussion
I re-creating a simple inventory that we have used for 30+ years and a basic calculation is giving me the hardest time. All I want to do is have it calculate =SUM(C5+D5) in cell D5
It will not allow me to stating it is a circular reference =(
I had it this way in the last one with no problems...is there a bi-pass method or settings change?
1 Reply
All I want to do is have it calculate =SUM(C5+D5) in cell D5 It will not allow me to stating it is a circular reference
It IS a circular reference. That's why you get that error message.
I'm going to hazard a guess: assuming you're just tracking an addition or subtraction to the inventory in Cell C5, and that column D contains the running inventory total, I'm guessing that the original formula in that prior spreadsheet, the one you're re-creating, was
=C5+D4
Which would take whatever is the change in the most current row of column C and incorporate it with the PRIOR row in column D, to give you the updated inventory.
If that guess is not correct, maybe you could help us help you by posting a copy of the old and new workbooks on OneDrive or GoogleDrive with a link pasted here that grants access.
