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
Highlighted
New Contributor

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

3 Replies
Highlighted

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

Highlighted
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?


Highlighted

just checked it is already automatic@JMB17