| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding one cell to another?
I want to add 1 cell to another then keep on adding to it. For example cell
B2 is 10 i want cell C3 to change to 10, but then if i change B2 to 5 i want C3 to read 15. I managed to do it once but then if i repeat the formula down the cells it seem to add every thing, i want cell C4 to add B4 and C5 to add B5 and so on. Any Ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding one cell to another?
http://www.mcgimpsey.com/excel/accumulator.html
-- Kind regards, Niek Otten Microsoft MVP - Excel "bouncer8" wrote in message ... |I want to add 1 cell to another then keep on adding to it. For example cell | B2 is 10 i want cell C3 to change to 10, but then if i change B2 to 5 i want | C3 to read 15. I managed to do it once but then if i repeat the formula down | the cells it seem to add every thing, i want cell C4 to add B4 and C5 to add | B5 and so on. | Any Ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding number to a cell reference not to the contents | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Linear Mode
