running total of the difference of 2 columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
in c1 type

=a1-b1

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

Randall
 
Back
Top