Forum Discussion

Alan Hitt's avatar
Alan Hitt
Copper Contributor
Oct 19, 2018

Excel

The auto sum feature does not work after I initially set up adding a column of numbers. For example, when I set up to add a few numbers the function works but when I add additional numbers in the column, the feature does not add those to the column. 

 

Any thoughts why? It had been working in the past.

excel
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Oct 20, 2018
    check the range -
    assuming Column A and your formula is =sum(A:A)
    that should do it.
    • Lorenzo Kim's avatar
      Lorenzo Kim
      Bronze Contributor
      Oct 22, 2018
      check the range of the SUM.
      example the formula is =SUM(A2:A12)
      it is adding cells from A2 down to A12 only
      thus, if you enter a value at A13 - it won't add it.
      you have to change the formula to =SUM(A2:A13) and so on..
      a much better formula is the one I mentioned previously =SUM(A:A)
      you won't have to adjust the range every time you enter a value for Column A.
      HTH

Resources