Excel Spreadsheet Question
I want to have Excel remember a calculated number in a cell and be able to
accumulate any consecutive amounts to that number. This action must be a running record that is constantly being updated from a previous amount being added onto. |
Excel Spreadsheet Question
xlsboy
Is this what you ae looking to do? http://www.mcgimpsey.com/excel/accumulator.html Mike Rogers "xlsboy" wrote: I want to have Excel remember a calculated number in a cell and be able to accumulate any consecutive amounts to that number. This action must be a running record that is constantly being updated from a previous amount being added onto. |
Excel Spreadsheet Question
Thank you for your time. Very helpful.
"Mike Rogers" wrote: xlsboy Is this what you ae looking to do? http://www.mcgimpsey.com/excel/accumulator.html Mike Rogers "xlsboy" wrote: I want to have Excel remember a calculated number in a cell and be able to accumulate any consecutive amounts to that number. This action must be a running record that is constantly being updated from a previous amount being added onto. |
Excel Spreadsheet Question
Take careful note of the fact you will have no way of auditing if you make a
mistake in your accumulator cell. Gord Dibben MS Excel MVP On Wed, 30 Jan 2008 05:49:00 -0800, xlsboy wrote: Thank you for your time. Very helpful. "Mike Rogers" wrote: xlsboy Is this what you ae looking to do? http://www.mcgimpsey.com/excel/accumulator.html Mike Rogers "xlsboy" wrote: I want to have Excel remember a calculated number in a cell and be able to accumulate any consecutive amounts to that number. This action must be a running record that is constantly being updated from a previous amount being added onto. |
All times are GMT +1. The time now is 09:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com