ExcelBanter - Adding entry in one cell to a running total in another cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding entry in one cell to a running total in another cell (https://www.excelbanter.com/excel-worksheet-functions/223979-adding-entry-one-cell-running-total-another-cell.html)

TommyB

Adding entry in one cell to a running total in another cell

Is it possible to enter a number in cell A1 and have it added to a number
that already exists in cell A5 and the new total replaces the current total
in A5?
--
TommyB

Gord Dibben

Adding entry in one cell to a running total in another cell

Possible but not recommended.

How would you audit for errors?

See JE McGimpsey's site for methods.

http://www.mcgimpsey.com/excel/accumulator.html

Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 14:53:01 -0700, TommyB
wrote:

Is it possible to enter a number in cell A1 and have it added to a number
that already exists in cell A5 and the new total replaces the current total
in A5?

All times are GMT +1. The time now is 02:21 AM.