Hi

In column B you see the Total including this week's entries
(adjusting as more entries are made to this week)
In column C you see the Total up to last week
in Column D you see this weeks figure
in column E you see the week before's figure
in column F you see the figure for the week before that, and so on.

What else do you need to see?

--
Regards

Roger Govier


"EXCEL Girl" wrote in message
...
Thanks Roger,

Your formula is to compare this weeks accumulating total to the
previous
weeks accumulating total. However, I'm wanting to compare the number
of
interactions this week to the number of interactios from previous
week. and
afterwhich, I want to add the number of this weeks activities to the
accumulating total.

"EXCEL Girl" wrote:

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