Formula based on last row entered...

[kirbster]

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...

 

[ken2step]

Is there a reason you can not just sum(B1:B9)???

 

[cherria]

If the weights were in B2:B10

then in B11 you could enter

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

 

[just_jon]

Book1
	A	B	C	D
1	Day1	200
2	Day2	198
3	Day3	196
4	Day4	192
5	Day5
6	Day6
7	Day7
8	Day8
9	Day9
10
11	Total=	8
Sheet1

 

[fairwinds]

Hi,

Try:

Book1
	A	B	C	D
1	Day1	200
2	Day2	198
3	Day3	196
4	Day4	192
5	Day5
6	Day6
7	Day7
8	Day8
9	Day9
10	Totals	8
Sheet4

 

[ken2step]

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

 

[kirbster]

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