# Formula based on last row entered...

#### kirbster

##### Board Regular
I have a weightloss table that is completed on a weekly basis.

I have a formula that calculates the total weightloss since the original weigh in.

So,

Day 1 | 200
Day 2 | 198
Day 3 | 196
Day 4 | 192
Day 5 |
Day 6 |
Day 7 |
Day 8 |
Day 9 |
Totals | ="Day 1"-"Day 4"

This works fine until tomorrow when I need to add a new weight into Day 5...question is, what formula could I use to to end up with ="Day 1"-"latest weight"?

Thanks...

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Is there a reason you can not just sum(B1:B9)???

If the weights were in B2:B10

then in B11 you could enter

=B2-offset(b1,count(B2:B10),0)

Book1
ABCD
1Day1200
2Day2198
3Day3196
4Day4192
5Day5
6Day6
7Day7
8Day8
9Day9
10
11Total=8
Sheet1

Hi,

Try:
Book1
ABCD
1Day1200
2Day2198
3Day3196
4Day4192
5Day5
6Day6
7Day7
8Day8
9Day9
10Totals8
Sheet4

Boy did I mis read that post!!! Good ideas guys!

Thats perfect...thankyou folks...what would i do eh!

Replies
6
Views
242
Replies
0
Views
86
Replies
14
Views
263
Replies
0
Views
108
Replies
1
Views
129

1,203,069
Messages
6,053,352
Members
444,655
Latest member
didr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back