What is the formula used to keep track of totals for a column?

[Guest]

I saw somewhere that you could keep track of the totals in a column such as
100|100
200|300
300|600
400|1000
500|1500

I was wondering what the formula for that was and if it could keep track if
you used negatives by subtracting it from the total.

 

[Bob Phillips]

Maybe I am missing something, but it is just

=SUM(A1:A100)

which manages negative numbers

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bernard Liengme]

Assuming you data is in A1:A6
In B1 =A1
In B2 =B1+A2 and copy down the column
negative values look after themselves
try it!

 

[Niek Otten]

=SUM($A$1:A1)

 

[Guest]

You could either calculate each cell as the sum of the cell above and the
cell left or the sum of all cells in the prior column through the current row.
If the data starts in A1, then for the first approach, in B1: =a1. And in
B2: =b1+a2. Autofill that formula down.
If the data is in column A, then for the second approach, in B1:
=sum(A$1:a1). Autofill that formula down.