Forum Discussion

serene06's avatar
serene06
Copper Contributor
Apr 12, 2022
Solved

Weight loss in lbs. and body fat %

Hi, I am tracking weight and body fat % bi-weekly.  I was wondering if there Is a way to update the total weight loss and body fat loss based on the updated data entered bi-weekly. Start Weight ...
excel
  • mtarler's avatar
    mtarler
    Apr 19, 2022

    serene06  In the attached I expanded the file/table to include ID and week and formatted as a table to use structured references.  The formulas find the value for the row with the same ID AND says "start" under the Week and subtract from there.  I do this all under 1 table as it does make a number of things easier (i.e. any kind of group metrics like my clients lost a total of  or average of ...).

    i also added another tab to help you pull ONLY a single person's info.  I used a pivot table but you could also use the FILTER() functions.

Usainamoh's avatar
Usainamoh
Copper Contributor
Dec 12, 2023

serene06 To update your total weight loss, just subtract your starting weight from your latest weight entry. For body fat loss, subtract your initial body fat percentage from the current one. If you're looking for extra support, you could try checking out a medical weight loss service like https://medicalweightlosslehighvalley.com/. They offer personalized guidance to help you reach your goals.

Resources