why does sum add up to ZERo? when it should not

%3CLINGO-SUB%20id%3D%22lingo-sub-1686461%22%20slang%3D%22en-US%22%3Ewhy%20does%20sum%20add%20up%20to%20ZERo%3F%20when%20it%20should%20not%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1686461%22%20slang%3D%22en-US%22%3E%3CP%3Eplease%20let%20me%20know%20why%20the%20sum%20is%20zero%20see%20attached%20screen%20shot%20-%20in%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1686461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1686644%22%20slang%3D%22en-US%22%3ERe%3A%20why%20does%20sum%20add%20up%20to%20ZERo%3F%20when%20it%20should%20not%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1686644%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F799441%22%20target%3D%22_blank%22%3E%40david_f1650%3C%2FA%3E%26nbsp%3BPerhaps%20a%20silly%20question%20from%20my%20side.%20You%20are%20adding%20up%20cells%20in%20row%20211.%20Which%20row%20is%20that%20in%20your%20schedule%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

please let me know why the sum is zero see attached screen shot - in 

3 Replies

@david_f1650 Perhaps a silly question from my side. You are adding up cells in row 211. Which row is that in your schedule?

It is the last row, with the totals. You can just barely see the address box to the far left, which confirms the active cell in column AZ is row 201.

To the OP - maybe check to see if your calculation is set to manual (Formulas tab, Calculation Options). If so, change it to automatic?


just checked it is already automatic@JMB17