I am working on creating a weight loss spread sheet for myself. I have columns starting with days of the week, date, and then weight. Column C is just an entire list of daily weigh-in's. I want to be able to see total weight lost by subtracting whatever the latest cell added, from the original weight which is in C2. What formula would be best to use so that the number adjusts daily to subtract the new number added in column c?
it would seem =$C$2- (your next cell in column C)
so if your next weight is in C8 then =$C$2-C8
you can drag that down and it will keep changing the cell from C8 to C9 to C10 etc.
hope that helps.
EDIT: you can also make it =IF(C3="","",$C$2-C3) and drag that down, then every where the cell in col C is empty (no weight yet) the formula will return blank, then when you put a value in the cell it will subtract it from C2.
Last edited by Sam Capricci; 10-21-2021 at 11:34 PM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
put this formula someplace OTHER THAN in column C from cell C2 or down (so it can be in cell C1, or in any other column)
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks