How do I keep a running total of pounds lost and percentage lost
 

We're having a weight loss competition at work and I'm trying to set up a
table that will show each persons weight each week, total loss/gain and
percentage of loss. Can anyone help me?

How do I keep a running total of pounds lost and percentage lost
 

Assuming the weekly weights of a single person are in a column (say in
A2:A10), the formulas:

=A3-A2
=(A3-A2)/A2

will show respectively the net weight change and percent change
(negative values indicate loss. These formulas should be placed in row
3 and can be copied down.

HTH
Kostis Vezerides

How do I keep a running total of pounds lost and percentage lost
 

Set up a table like this:
A B C D E X
1 Name Total Percent Start Week 1 Week #

In Cell B2: =D2-OFFSET(D2,0,COUNTA(D2:X2)-1)
In Cell C2: =B2/D2
Copy these formulas down for as many participants as you have.

List out all of your weeks and just enter the official weights each week.
Just make sure that "X" in the formula above is the column letter of your
last week (Figure a year's worth of weeks from the start--you should be good
to go)

Good luck!

"angel5959" wrote:

We're having a weight loss competition at work and I'm trying to set up a
table that will show each persons weight each week, total loss/gain and
percentage of loss. Can anyone help me?

How do I keep a running total of pounds lost and percentage lo
 

Thanks!

"BekkiM" wrote:

Set up a table like this:
A B C D E X
1 Name Total Percent Start Week 1 Week #

In Cell B2: =D2-OFFSET(D2,0,COUNTA(D2:X2)-1)
In Cell C2: =B2/D2
Copy these formulas down for as many participants as you have.

List out all of your weeks and just enter the official weights each week.
Just make sure that "X" in the formula above is the column letter of your
last week (Figure a year's worth of weeks from the start--you should be good
to go)

Good luck!

"angel5959" wrote:

We're having a weight loss competition at work and I'm trying to set up a
table that will show each persons weight each week, total loss/gain and
percentage of loss. Can anyone help me?

How do I keep a running total of pounds lost and percentage lo
 

Thanks!

"vezerid" wrote:

Assuming the weekly weights of a single person are in a column (say in
A2:A10), the formulas:

=A3-A2
=(A3-A2)/A2

will show respectively the net weight change and percent change
(negative values indicate loss. These formulas should be placed in row
3 and can be copied down.

HTH
Kostis Vezerides