How can I add the same cell to itself?? and then have the value given in another cell??
EXAMPLE
A1 to be used over and over to create a running total.
so...A1=A1+A1 and for it to keep the value.
so, it would be like 20+20+20 = 60 and the value 60 stored in another cell
perhaps A2
I can write a program to do this, but it would be DOS based, and I don't have the time...so any help would be greatly appreciated.
I know I can creat continuous cells to do this, but I don't want to do that, because I would have a page full of enteris, when I believe it should be possible to creat a running total with just one cell.
Thank you for any help you can offer!
EXAMPLE
A1 to be used over and over to create a running total.
so...A1=A1+A1 and for it to keep the value.
so, it would be like 20+20+20 = 60 and the value 60 stored in another cell
perhaps A2
I can write a program to do this, but it would be DOS based, and I don't have the time...so any help would be greatly appreciated.
I know I can creat continuous cells to do this, but I don't want to do that, because I would have a page full of enteris, when I believe it should be possible to creat a running total with just one cell.
Thank you for any help you can offer!