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?
|