Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rosebud_28
 
Posts: n/a
Default Automatically updating

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)?
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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



  #3   Report Post  
Automatically updating
 
Posts: n/a
Default

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




  #4   Report Post  
Automatically updating
 
Posts: n/a
Default

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




  #5   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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?



  #6   Report Post  
Automatically updating
 
Posts: n/a
Default

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?


  #7   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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 updating"
wrote in message ...
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?




  #8   Report Post  
gls858
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating calculations automatically when i enter in new data chica_guapa Excel Discussion (Misc queries) 1 February 8th 05 11:17 PM
Automatically Populating Worksheet from Collected Input for Pricelist David Littrell via OfficeKB.com Excel Worksheet Functions 1 January 6th 05 06:04 PM
Automatically Populating Worksheet from Collected Input for Pricelist David Littrell via OfficeKB.com Excel Worksheet Functions 0 January 6th 05 05:29 PM
Linked Sheets not updating automatically New User New Users to Excel 1 December 23rd 04 08:43 PM
getting data from 2 excel sheets automatically pinar Excel Worksheet Functions 0 November 9th 04 12:47 PM


All times are GMT +1. The time now is 04:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"