Discussion why does sum add up to ZERo? when it should not in Excel
https://techcommunity.microsoft.com/t5/excel/why-does-sum-add-up-to-zero-when-it-should-not/m-p/1686461#M75452
<P>please let me know why the sum is zero see attached screen shot - in </P>Sat, 19 Sep 2020 01:26:52 GMTdavid_f16502020-09-19T01:26:52Zwhy does sum add up to ZERo? when it should not
https://techcommunity.microsoft.com/t5/excel/why-does-sum-add-up-to-zero-when-it-should-not/m-p/1686461#M75452
<P>please let me know why the sum is zero see attached screen shot - in </P>Sat, 19 Sep 2020 01:26:52 GMThttps://techcommunity.microsoft.com/t5/excel/why-does-sum-add-up-to-zero-when-it-should-not/m-p/1686461#M75452david_f16502020-09-19T01:26:52ZRe: why does sum add up to ZERo? when it should not
https://techcommunity.microsoft.com/t5/excel/why-does-sum-add-up-to-zero-when-it-should-not/m-p/1686644#M75455
<P><LI-USER uid="799441"></LI-USER> Perhaps a silly question from my side. You are adding up cells in row 211. Which row is that in your schedule?</P>Sat, 19 Sep 2020 03:56:25 GMThttps://techcommunity.microsoft.com/t5/excel/why-does-sum-add-up-to-zero-when-it-should-not/m-p/1686644#M75455Riny_van_Eekelen2020-09-19T03:56:25ZRe: why does sum add up to ZERo? when it should not
https://techcommunity.microsoft.com/t5/excel/why-does-sum-add-up-to-zero-when-it-should-not/m-p/1686819#M75462
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.<BR /><BR />To the OP - maybe check to see if your calculation is set to manual (Formulas tab, Calculation Options). If so, change it to automatic?<BR /><BR /><BR />Sat, 19 Sep 2020 06:03:42 GMThttps://techcommunity.microsoft.com/t5/excel/why-does-sum-add-up-to-zero-when-it-should-not/m-p/1686819#M75462JMB172020-09-19T06:03:42ZRe: why does sum add up to ZERo? when it should not
https://techcommunity.microsoft.com/t5/excel/why-does-sum-add-up-to-zero-when-it-should-not/m-p/1687263#M75473
<P>just checked it is already automatic<LI-USER uid="675152"></LI-USER> </P>Sat, 19 Sep 2020 11:54:04 GMThttps://techcommunity.microsoft.com/t5/excel/why-does-sum-add-up-to-zero-when-it-should-not/m-p/1687263#M75473david_f16502020-09-19T11:54:04Z