a1 = sum(a1;a2)
 

Hi
i have a number, for example in cell a2
i change every time this number and want to have a summery of these changed
numbers in other cell (for example a1), without using the table of changed
numbers.
for example if i use the a1 = sum(a1;a2) the excel will issue the error.

please help me.

a1 = sum(a1;a2)
 

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"M. Hossein Ghomian" <M. Hossein wrote in message
...
| Hi
| i have a number, for example in cell a2
| i change every time this number and want to have a summery of these changed
| numbers in other cell (for example a1), without using the table of changed
| numbers.
| for example if i use the a1 = sum(a1;a2) the excel will issue the error.
|
| please help me.

a1 = sum(a1;a2)
 

And note John's warning that there will be no "audit trail" to correct errors in
entry.


Gord Dibben MS Excel MVP

On Sun, 6 Apr 2008 11:51:44 +0200, "Niek Otten" wrote:

Look he

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