a1 = sum(a1;a2)

[M. Hossein Ghomian]

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.

 

[Niek Otten]

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP