Automatically updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 am still looking for help on this worksheet. I would appreciate a response
from anyone who could assist me. Please.
 
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



"Automatically updating"
 
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!
 
The formula =B2+C2 may not be the best solution. Also, when you enter it
into another row manually, you need to manually update the row references,
or use Copy and Paste to get the row references to update.

Usually, an accumulator is used like

Col B Col C
Monthly Yearly (Row 1)
100 100
200 300

and the formulas would be (in cell C2)

=B2

and in cell C3, you would use the formula

=B3+C2

and _copy_ that cell down the column so the next row has = B4+C3, etc....

HTH,
Bernie
MS Excel MVP
 
Automatically said:
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?

:
Click to expand...
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
 
Back
Top