Hi

I thought that is what I was achieving, other than my Previous total was
for all weeks from 1 week ago up to potentially 250 weeks ago.

On a new blank sheet, set up the formulae in the columns as per my
previous post.
In cell E2 enter 1, in F2 enter 4
Condition A
Now cell B2 Total will equal 5
cell C2 Previous will equal 5
cell D2 This week will equal nothing
Condition B
Enter 2 in cell D2 (this week's value)
Now cell B2 Total will equal 7
cell C2 Previous will equal 5

Insert a new column at D, by Right clicking on the column heading and
choosing Insert
Condition C
Now cell B2 Total will equal 7
cell C2 Previous will equal 7
cell D2 This week will equal nothing
Because, at that point, when you insert new blank week, the cumulative
total will equal the previous weeks cumulative total

If you only want to accumulate up to 5 weeks data, (this week plus 4
weeks previous) then change the formula in C2 to
=SUM(INDEX($2:$2,1,5):INDEX($2:$2,1,8))

--
Regards

Roger Govier


"EXCEL Girl" wrote in message
...
The information you supplied was somewhat helpful but it's still not
where
I'm trying to go.

I think this info will help you understand more of what I'm trying to
do:

- For example: The MTD total for Failed Customer Service total is 5
(weeks
1 & 2).
- Let's say we are coming into the 3rd week. All of the information
from
the current interactions will become the previous week interactions in
this
case; the number will be 1 for Failed Customer Service (the new
previous
week).

- The 3rds weeks MTD total for Failed Customer service will be 5 + new
number for the 3rd weeks number of failed customer service.

o Lets say for example the number is 2.

o Therefore the new MTD for Failed Customer service will be
will 7.

I need for the MTD column to retain the last's weeks MTD total and
then I
need to add the new current information to that total. (i.e. this
week 2 + 5
=7..Next week ( New number of Failed Customer Interactions + 7 = New
MTD
Column).