Discussion Auto Sum Errors in Excel
https://techcommunity.microsoft.com/t5/excel/auto-sum-errors/m-p/2694346#M111857
<P>I have a list of numbers all formatted as follows: 100.0000 </P><P>I try to AutoSum the list of numbers; it has always added up the numbers & put the sum in the field following those I selected for summing. </P><P>However, instead of adding them up it inserts a sum formula in the top field. </P><P>Why? What have I done wrong & how do I get AutoSum working again. </P><P>Thanks,</P>Sat, 28 Aug 2021 01:13:03 GMTssk20212021-08-28T01:13:03ZAuto Sum Errors
https://techcommunity.microsoft.com/t5/excel/auto-sum-errors/m-p/2694346#M111857
<P>I have a list of numbers all formatted as follows: 100.0000 </P><P>I try to AutoSum the list of numbers; it has always added up the numbers & put the sum in the field following those I selected for summing. </P><P>However, instead of adding them up it inserts a sum formula in the top field. </P><P>Why? What have I done wrong & how do I get AutoSum working again. </P><P>Thanks,</P>Sat, 28 Aug 2021 01:13:03 GMThttps://techcommunity.microsoft.com/t5/excel/auto-sum-errors/m-p/2694346#M111857ssk20212021-08-28T01:13:03ZRe: Auto Sum Errors
https://techcommunity.microsoft.com/t5/excel/auto-sum-errors/m-p/2698338#M112051
Can you provide a screenshot of it?Mon, 30 Aug 2021 11:30:54 GMThttps://techcommunity.microsoft.com/t5/excel/auto-sum-errors/m-p/2698338#M112051Juliano-Petrukio2021-08-30T11:30:54ZRe: Auto Sum Errors
https://techcommunity.microsoft.com/t5/excel/auto-sum-errors/m-p/2703781#M112226
here is the screen shot - The problem is specific to this worksheet as AutoSum works in others.<BR />I have tried every I know to insert the full sheet & to then copy & paste, nothing worked. Sorry<BR /><BR />PTO Balance<BR />=SUM(A2:A29 This field to the left had a PTO Balance also but the formula was written over the<BR />numbers in the field when I clicked AutoSum after highlighting the entire<BR />column of numbers expecting the total to be added to the 1st empty field at<BR />the bottom of the list. Nothing appeared there.<BR />I'm sorry I could not send you the entire worksheet.<BR /><BR />Tue, 31 Aug 2021 17:10:11 GMThttps://techcommunity.microsoft.com/t5/excel/auto-sum-errors/m-p/2703781#M112226skluin2021-08-31T17:10:11Z