How can i add a number in a cell, but still keeping the old number in the sum.
U Ulrik Martinsson Jun 10, 2004 #1 How can i add a number in a cell, but still keeping the old number in the sum.
H Harald Staff Jun 10, 2004 #2 You'd need a macro for that, or some clever setup of circular references. But why ? A single worksheet has almost 17 million cells and excel is built for "each element in separate cells". HTH. Best wishes Harald
You'd need a macro for that, or some clever setup of circular references. But why ? A single worksheet has almost 17 million cells and excel is built for "each element in separate cells". HTH. Best wishes Harald
F Frank Kabel Jun 10, 2004 #3 Hi you'll need VBA for this. But as Harald I wouldn't recommend this. For a macro solution see: http://www.mcgimpsey.com/excel/accumulator.html
Hi you'll need VBA for this. But as Harald I wouldn't recommend this. For a macro solution see: http://www.mcgimpsey.com/excel/accumulator.html
