Forum Discussion
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 col...
check the range -
assuming Column A and your formula is =sum(A:A)
that should do it.
assuming Column A and your formula is =sum(A:A)
that should do it.
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
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