moving cell

[Elbowhite]

Thx for the advice on my problem few post down!
But now I have a new problem :/
Lets say there is a number in i.e. A10 and in two next rows in the same
column (A11, A12...). And now I want the sum oif those three rows in for
example A15. Now, thats not a problem to do, but this is: If the user writes
a number in A13, I want the sumary in the A15 move to A16 and to sum up the
number in A13. I hope you understand the problem. So, if a user enters only
one number (for example 1, in A14), the sumary in A16 needs to move to A17
and that 1 (from the A14) needs to sum to the whole sumary.
So that sumary is moving all the time lower and lower. How to do something
like that? It would be alot easier if there was something like a FOR
function like in C (programing).
And if a user deletes a number in a column (like A12), all the number that
were under it need to move one row higher. IS that possible?

 

[Guest]

First you must sum rows 10,11,12,13 and 14 and put the formula in row 15.
Then if a user adds a number, he/she should insert a row first. That will
move the sum down one line, and the new number will be added. Note: the row
directly above the row where the formula is should stay blank. (in this case
row 14 should stay blank).
hope this helps?

 

[Elbowhite]

First you must sum rows 10,11,12,13 and 14 and put the
formula in row 15. Then if a user adds a number, he/she
should insert a row first. That will move the sum down
one line, and the new number will be added. Note: the row
directly above the row where the formula is should stay
blank. (in this case row 14 should stay blank).
hope this helps?

Thats a little complicated, couse I'm doing this thing for people who don't
know anything except typing numbers in cells, everything else should be
automatized. Isn't there another way to just type in numbers in rows and
formula to move all the time down summed up?
Thx anyway

 

[Guest]

No, there is no way to do that. You could try putting your formula further
down, or on a separate page. Do the other users have to see the sum? If not,
you could easily put the totals on a separate tab and sum the whole column.