Forum Discussion
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.