ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Auto addition to a cell (https://www.excelbanter.com/excel-discussion-misc-queries/37230-auto-addition-cell.html)

ahemani

Auto addition to a cell
 
Can excel automatically add together a new value that is typed into a cell
that already had a value in it. For example if B10 had a value of 55 in it
and you typed in the number 5 in that cell, it would automatically display 60
as the new value in that cell ?

Rowan

It is not really recommended to do this as you have no history and can't
track errors but have a look at

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

Regards
Rowan

"ahemani" wrote:

Can excel automatically add together a new value that is typed into a cell
that already had a value in it. For example if B10 had a value of 55 in it
and you typed in the number 5 in that cell, it would automatically display 60
as the new value in that cell ?



All times are GMT +1. The time now is 10:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com