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

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

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

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

If you entered

=B2+C2

into C3, then you told the formula to add B2 (30,000) and C2 (30,000).

If you only want it to sum Smith's values, use

=B3+C3

Note that accumulators like this can be very difficult to edit and
audit.

For additional types of accumulators, you can check out

http://www.mcgimpsey.com/excel/accumulator.html



In article ,
"Automatically updating"
wrote:

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?

I keep getting the same formula from everyone, but it is not working. It
works as long as I enter it in just the first row. But, when I enter the
same formula for the next row (changing the row # of course) it doubles the
amount in the row above it.
HELP!

"JE McGimpsey" wrote:

If you entered

=B2+C2

into C3, then you told the formula to add B2 (30,000) and C2 (30,000).

If you only want it to sum Smith's values, use

=B3+C3

Note that accumulators like this can be very difficult to edit and
audit.

For additional types of accumulators, you can check out

http://www.mcgimpsey.com/excel/accumulator.html



In article ,
"Automatically updating"
wrote:

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?

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