What formula do I use to show total weight loss to date so I don’t have to manually enter the formula on that one day.
Example, started 229.6 pounds then enter next weight 229 so total loss to date is .6 pounds
next time I weigh 228.4 so what formula is used to show the original weight of 200 less today 228.4 to show 2 pounds lost to date ?
thank you….
Karen’s MacBook Pro
One way would be something like this:
The first row is a Header Row (shaded by default).
In C2 I entered
=B2−B$1
And filled that down the column by hovering and dragging the yellow dot down.
If you want to get fancier you could use this in B2, and fill it down:
=IF(B2="","",B2−B$1)
That will make the cell appear blank unless you have entered a value on that row in column B.
SG
One way would be something like this:
The first row is a Header Row (shaded by default).
In C2 I entered
=B2−B$1
And filled that down the column by hovering and dragging the yellow dot down.
If you want to get fancier you could use this in B2, and fill it down:
=IF(B2="","",B2−B$1)
That will make the cell appear blank unless you have entered a value on that row in column B.
SG
I figured it out !
I copied cell e3 then grabbed remaining cells in total loss column then I paste and match style
I entered fake figure in the next cell and it showed total loss to date
thank you !
Thank you.
i tried but didn’t work
this is my sheet. The total loss column E is the one I can’t get to work. I need it to be the c2 cell starting weight minus todays weight, tomorrow etc. I can manually do each cell in E column but prefer a formula
am I missing something in what you wrote ?
Something I do, especially in numbers, is break my static values off into their own table.
this makes it much easier to work with, as I can just reference the cell I want and mark it as locked to that cell.
I remade your tables and made them reference the static table for your other columns to made that go down with the same data.
Numbers formula query
