[nick]

I am currently using a spreadsheet to keep a record of hours worked a week
for the year.
i have set up as follows: jan1. jan8. jan15. Jan22 etc.
42:11 30:12 15:17 50:40

I want to create a table below to show the last 3 weeks only, and to change
when i enter in the main table each week.

[Bob Phillips]

=SUM(INDEX(2:2,COUNT(2:2)):INDEX(2:2,COUNT(2:2)-2))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Nick" wrote in message
...
I am currently using a spreadsheet to keep a record of hours worked a week
for the year.
i have set up as follows: jan1. jan8. jan15. Jan22 etc.
42:11 30:12 15:17 50:40

I want to create a table below to show the last 3 weeks only, and to
change
when i enter in the main table each week.