sum problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2505139%22%20slang%3D%22en-US%22%3Esum%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2505139%22%20slang%3D%22en-US%22%3E%3CP%3Emy%20excel%20sheets%20for%20monthly%20budgets%20is%20now%20not%20adding%20horizontally%2C%20its%20added%20with%20the%20%3Dsum(%20commands%20for%20all%20pages%20till%20now%2C%20please%20help%20with%20a%20fix.%20see%20error%20attached%20when%20i%20open%20excel.%20I%20dont%20know%20how%20to%20find%20theis%20error%20if%20it%20has%20something%20to%20do%20with%20not%20adding%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel%20error.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292804i7A34953289701E8D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22excel%20error.PNG%22%20alt%3D%22excel%20error.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2505139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2505203%22%20slang%3D%22en-US%22%3ERe%3A%20sum%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2505203%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1092641%22%20target%3D%22_blank%22%3E%40debpur%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20not%20a%20sum%20problem%20but%20a%20circular%20reference%20problem.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.google.com%2Fsearch%3Fq%3Dremove%2Bcircular%2Breferences%2Bfrom%2Bexcel%26amp%3Boq%3Dremove%2Bcircular%2Bref%26amp%3Baqs%3Dchrome.2.0i19j69i57j0i19l2j0i19i395l2j0i19j0i19i22i30l3.12765j1j7%26amp%3Bsourceid%3Dchrome%26amp%3Bie%3DUTF-8%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ERemove%20the%20circular%20reference.%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

my excel sheets for monthly budgets is now not adding horizontally, its added with the =sum( commands for all pages till now, please help with a fix. see error attached when i open excel. I dont know how to find theis error if it has something to do with not adding

excel error.PNG

1 Reply

@debpur 

That is not a sum problem but a circular reference problem.

Remove the circular reference.