Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating calculations automatically when i enter in new data | Excel Discussion (Misc queries) | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions | |||
Linked Sheets not updating automatically | New Users to Excel | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |