Tracking Weight Loss in Excel

**hbretthill** · 08-02-2008, 01:54 PM

How do I track my total weight loss in excel? Here is an example of what I am trying to do.

8/1/2008 228lbs
8/2/2008 225lbs
8/3/2008 223lbs

Total 5lbs

I would like use a formula that would subtract my absolute weight loss total day by day in August. Basically, I want the total "cell" to equate to my total weight loss in August. For Example after 8/3/08 the "total cell" should equate to 5 lbs. What formula do I use to do this? Thank you.

**VBA Noob** · 08-02-2008, 02:20 PM

Does example help

Formula used

="Total "& B1-LOOKUP(9^9,B:B)

Column B formatted as

General "lbs"

VBA Noob

**hbretthill** · 08-02-2008, 02:49 PM

Thank you, but I tried to use the formula given but it does not work.

I need a formula that will calculate the my total weight loss over 7 days. Example:

Cell Weight
B2 228
B3 225
B4 223
B5 222
B6 221
B7 219
B8 217

Total: 11 lbs

As you can see the total weight loss is 11 lbs from B2 to B8. B2 equals 228 and at B8 my weight was 217lbs for a total of 11lbs lost. What formula will calculate this total instead of subtracting it manually?

Thanks.

**VBA Noob** · 08-02-2008, 03:05 PM

Thank you, but I tried to use the formula given but it does not work.
I need a formula that will calculate the my total weight loss over 7 days. Example:

It does work but you just moved the goal post e.g add another variable with 7days. Any other curve balls. What happens after 7 days

VBA Noob

**kthrynileen** · 11-03-2013, 06:40 PM

Originally Posted by VBA Noob

It does work but you just moved the goal post e.g add another variable with 7days. Any other curve balls. What happens after 7 days

VBA Noob

Hello - is there something I can add to the formula to make it round the results? Would like two decimals if that's possible.

**alansidman** · 11-03-2013, 06:49 PM

Hi kthrynileen

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**kthrynileen** · 11-03-2013, 07:42 PM

Originally Posted by alansidman

Hi kthrynileen

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Apologies - posted here because I used the formula suggested above. Will repost in separate thread & hope I get the details correct.