ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Spreadsheet Question (https://www.excelbanter.com/excel-discussion-misc-queries/174914-excel-spreadsheet-question.html)

xlsboy

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.

Mike Rogers[_2_]

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.


xlsboy

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.


Gord Dibben

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