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