Thanks Bernard. What you provided will work if I wanted more of a running
MTD total. What I have is a spread sheet that looks similar to this:
As you can see the WTD amount will be entered for each cat. What I am
looking for is a way to add across to get the MTD value for Cat A. (in other
words MTD = MTD + WTD for Cat A; 3 + 0 = 3 (assuming this is the first week
of the month). I can use the SUM function to get the grand total of all MTD
values.
I hope the example explains my situation. This seems so simple in concept,
but I think I can't see the forest for the trees.

Company A
Date Goes Here
Categories WTD MTD YTD
Group 1 12 12 301 (note: @sum is used to get these ttls)
Cat A 3 3 120 (this ex represents the first week)
Cat B 1 1 16
Cat C 3
Cat D 1 1 3
Cat E 2
Cat F 4 4 58
Cat G 3
Cat H 2 2 76
Cat I 2
Cat J 1 1 9
Cat K 8
Cat L 1

"Bernard Liengme" wrote:

An alternative to Niek's solution is:
=SUM($A$1:A1) in B1 and copy down as needed
and if you want to see nothing when the A cell is empty:
=IF(ISBLANK(A1),"",SUM($A$1:A1))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Niek Otten" wrote in message
...
B1: =A1
B2: =B1+A2, Copy down as far as needed

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ken" wrote in message
...
| This is so simple I cannot believe I can't see the answer. I have a
| situation where column A is the current weeks totals (ex: a1 = 6, a2 =
10, a3
| = 12). I need to have column b equal the month-to-date totals (b1 =
b1+a1,
| b2 = b2+a1, b3=b3+a3). I realize this is dealing with circular
references,
| but I find it hard to believe that a situation like this cannot be
easily
| resolved. Anyone come across this and find a solution?