I am still looking for help on this worksheet. I would appreciate a response
from anyone who could assist me. Please.

"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..........Dec .....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)?