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? |
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? |
All times are GMT +1. The time now is 12:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com