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.

"Arenlor" wrote:

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.