excel function sum question?

Question

How do I make a column of numbers update with the new number after completing the function sum that i have setup.

I want the numbers to change in my column from the functions sum.

Answer 1

The SUM() function will automatically update the total when you input new numbers into the range of cells. Unless you have turned the automatic calculation off.

So put the sum function anywhere you want it - typically at the bottom of a column of numbers. In cell A26 you would put:

=SUM(A1:A25)

Any other cells in your worksheet that refer to cell A26 will also be automatically updated. You can not update a cell in the range of the sum function with the result of the sum function - this is a circular reference and Excel will give you an error message.

Answer 2

Hi. I take it that you want to be able to add numbers into col A (for example) after you have applied the SUM function.

I have found that the easiest way to do this is to apply the SUM function to the next col. That way, you do not have to continually add rows in order to input a new number.

Ex: Column A has a list of 25 numbers in it. Place the following SUM function into the top cell in Column B. =SUM(A:A).
Now when you input a new number into the next blank cell in Col A, you will see a running total in Col B.

Hope this is what you meant :)

Answer 3

one way is to create someone-defined function so as which you will hint whilst a1 became as much as date. you notice, Excel interprets an replace as a correction. yet in any different case is to place your updates on distinctive cells --one replace - one cellular. Then upload those to b2. So, the formula for b2 then could be like = a1+a2+a3+a4+a5......