Automatically updating wrote:
My example is like #2.
Name.......MTD.....YTD

I changed the iteraion values as indicated, but now when I enter my formula
in the second row down it doubles the first row amount.
example MTD YTD
doe, john........30,000............30,000(=b2+c2)
smith, don.......20,000...........when I enter the same formula here my
30,000 turns into 60,000. why?

"JulieD" wrote:


Hi

do you have
...........A...........B...............C........ ....M........N
1.......Item......Jan.............Feb..........D ec.....YTD

if so the formula in N2 would be =SUM(B2:M2)

or do you have
.........A...........B..............C
1.....Item.......Mth Value...YTD Value

if so the formula in C2 would be
=B2+C2
but you'll have to choose tools / options / calculation and tick the
Iterations box and set the maximum value to 1

Cheers
JulieD

"rosebud_28" wrote in message
...

How can I get numbers in one column (ie Year-to-date) to automatically
update
when I add new numbers in another column (ie Month-to-date)?



I would recommend having a column for each month with a YTD column
that way you can sum each row for a YTD and you will be able to see
at a glance what the MTD total was for each person in each month.
You could then sum the YTD column to get a total YTD for all rows.
Just seems a little more informative and easier to maintain to me.
You could always hide the previous month columns if you didn't want
to see them.

gls858