running total of the difference of 2 columns?

[Guest]

hi
need help agai

i want column C to be a running total of (columnA-columnB

EXAMPL

a1 =2 b1=-3.5 then C1 should be -1.
a2=4 b2=0 then C2 should be 2.
a3=1 b3=-2 then C3 should be 1.

Anyway i can get column c to do this

Thanks in advance GAME

 

[J.E. McGimpsey]

One way:

C1: =SUM(A$1:B1)

copy down as far as desired.

 

[Randall Roberts]

in c1 type

=a1-b1

in c2
=(A2+C1)-B2
copy this formula down for all the rows you are using

Randall

 

[Guest]

Thanks again J

worked like a charm