running total of difference

[Jimbo]

ha, that subject line probably doesn't make sense, huh?
anyway, what i want to do is keep track of total weight loss.
what i'd like to do is in A1 have my starting weight, then in Column B,
track my weekly weight loss all the way down. So, in B1 will be "200", in B3
"193", B4 = "185", etc.

Is there a way that in C1 have a running total of pounds loss? in the above
example it would give me the result of "15"

TIA,

James

 

[Don Guillett Excel MVP]

ha, that subject line probably doesn't make sense, huh?
anyway, what i want to do is keep track of total weight loss.
what i'd like to do is in A1 have my starting weight, then in Column B,
track my weekly weight loss all the way down. So, in B1 will be "200", inB3
"193", B4 = "185", etc.

Is there a way that in C1 have a running total of pounds loss? in the above
example it would give me the result of "15"

TIA,

James

Unless I'm missing something, in c2
=$b$1--b2
copy down

 

[Jimbo]

thanks James! wasn't exactly what i was looking for but it did put me on the
right track!
what i was hoping to do is have c1 auto update. so that if i actually put on
weight, it would add that total as well.
So if B5 in the example below was "187" then C1 would reflect a total of
"13".

ha, that subject line probably doesn't make sense, huh?
anyway, what i want to do is keep track of total weight loss.
what i'd like to do is in A1 have my starting weight, then in Column B,
track my weekly weight loss all the way down. So, in B1 will be "200", in
B3
"193", B4 = "185", etc.

Is there a way that in C1 have a running total of pounds loss? in the
above
example it would give me the result of "15"

TIA,

James

Unless I'm missing something, in c2
=$b$1--b2
copy down

 

[Jimbo]

i meant to thank Don!

 

[Stan Brown]

ha, that subject line probably doesn't make sense, huh?
anyway, what i want to do is keep track of total weight loss.
what i'd like to do is in A1 have my starting weight, then in Column B,
track my weekly weight loss all the way down. So, in B1 will be "200", in B3
"193", B4 = "185", etc.

Is there a way that in C1 have a running total of pounds loss? in the above
example it would give me the result of "15"

In C1, put
=A$1-B1
then click and drag to fill column C. The $ in A$1 says when the
formula is copied the 1 will not change.