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.

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)


"Arenlor" wrote in message
...
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.

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!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Arenlor" wrote in message
...
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.

=SUM($A$1:A1)

--
Kind regards,

Niek Otten

"Arenlor" wrote in message
...
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.

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.