Here is a small portion of the spreadsheet and my problem.
Week 1 Week 2 Wk 3
Period to date

TY Ly % TY LY % TY Ly %
TY LY %

12 10 20% 10 10
12 30 -60%

As you can see, I have entered data in week one as 12 versus last year's ten
which gives me a 20% increase for the week. But as you can see in the period
to date column which shows a total of all the three weeks as 30 the
comparison is against the 30 which includes weeks one, two and three
together. What I would like to have happen is when I enter data for week one,
the data under the period to date also reflects that so for instance in the
example above the TY period to date total would also show 10 for last year to
reflect the 20% increase shown in week one. However, when I enter week two's
data for this year...say another 12 then I would want the total in Period to
date to show the 2 weeks sales ie 24 AND the total Period to Date for LY to
show also the total of weeks one and two ie 20. This would show a true
comparison between this year after two weeks and last year after 2 weeks and
the percentage would be correct. Subsequently, when I enter the third weeks'
sales say another 12, the period to date this year would then show 36 and the
period to date for last year would show 30. How do I create a formula that
would allow the number in the period to date last year column to reflect the
data entries as I make them in weeks one, then two then three?? HELP PLEASE
John